SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 Old Forums
 CLOSED - General SQL Server
 insert problem
 Forum Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

obewankanoochie
Starting Member

24 Posts

Posted - 07/21/2004 :  21:50:09  Show Profile
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 - 07/21/2004 :  21:54:03  Show Profile
post your error message
Go to Top of Page

obewankanoochie
Starting Member

24 Posts

Posted - 07/21/2004 :  21:56:09  Show Profile
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.
Go to Top of Page

timmy
Flowing Fount of Yak Knowledge

Australia
1242 Posts

Posted - 07/21/2004 :  21:57:08  Show Profile  Visit timmy's Homepage
How are you running the statement?

Are you testing it using QA?

Go to Top of Page

obewankanoochie
Starting Member

24 Posts

Posted - 07/21/2004 :  21:57:59  Show Profile
running it through an ASP page where I can upload my pictures.

Edited by - obewankanoochie on 07/21/2004 21:58:19
Go to Top of Page

slacker
Posting Yak Master

115 Posts

Posted - 07/21/2004 :  22:29:00  Show Profile
Do a response.write on your sql statement right before it executes. SOmething like this

Response.Write strSql
Response.End


Take that and post it in query analyzer and run it.. also post it here.
Go to Top of Page

obewankanoochie
Starting Member

24 Posts

Posted - 07/21/2004 :  22:39:24  Show Profile
Ahhh, I got it now. String was too long for field. Thanks everyone!
Go to Top of Page
  Previous Topic Topic Next Topic  
 Forum Locked
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.09 seconds. Powered By: Snitz Forums 2000