Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
obewankanoochie
Starting Member
24 Posts |
 Posted - 2004-07-21 : 21:50:09
|
insert into tblPictures (picimage, picimagedescription, picsubmitteddate) values('{E9AA68AE-0B97-46EF-9CDE-509E5231B636}_bullfight.jpg', 'test picture description', '7/21/04 8:40:18 PM')The characters "{" and "}" aren't allowing me to insert this statement. I'm running SQL 7 and the column is varchar. Any suggestions? Thanks. |
|
|
slacker
Posting Yak Master
115 Posts |
Posted - 2004-07-21 : 21:54:03
|
| post your error message |
 |
|
|
obewankanoochie
Starting Member
24 Posts |
Posted - 2004-07-21 : 21:56:09
|
| There is no error message. It just doesn't insert. It does when I use a file that doesn't include those characters. However, I cannot remove the characters from the file names that already have them. |
|
|
|
timmy
Master Smack Fu Yak Hacker
1242 Posts |
Posted - 2004-07-21 : 21:57:08
|
| How are you running the statement?Are you testing it using QA? |
|
|
|
obewankanoochie
Starting Member
24 Posts |
Posted - 2004-07-21 : 21:57:59
|
| running it through an ASP page where I can upload my pictures. |
|
|
|
slacker
Posting Yak Master
115 Posts |
Posted - 2004-07-21 : 22:29:00
|
| Do a response.write on your sql statement right before it executes. SOmething like thisResponse.Write strSqlResponse.EndTake that and post it in query analyzer and run it.. also post it here. |
|
|
|
obewankanoochie
Starting Member
24 Posts |
Posted - 2004-07-21 : 22:39:24
|
| Ahhh, I got it now. String was too long for field. Thanks everyone! |
|
|
|
|
|
|
insert problem