Current location: Hot Scripts Forums » Programming Languages » ASP » SQL Code Syntax error...need help...missing operator


SQL Code Syntax error...need help...missing operator

Reply
 
LinkBack Thread Tools Display Modes
  #1 (permalink)  
Old 09-02-03, 07:30 AM
geneane's Avatar
geneane geneane is offline
Newbie Coder
  
Join Date: Sep 2003
Location: The Carolinas
Posts: 59
Thanks: 0
Thanked 0 Times in 0 Posts
Unhappy SQL Code Syntax error...need help...missing operator
++++++++++++++++++++++++++++++++++++++++++++++
Help........Please.....

I am getting this syntax error and cannot figure out what the problem is. There's something missing or wrong in the following code:

++++++++++++++++++++++++++++++++++++++++++++++
Last edited by geneane; 09-02-03 at 07:40 PM.
Reply With Quote
  #2 (permalink)  
Old 09-02-03, 07:40 AM
!!! HotCGIScripts !!!'s Avatar
!!! HotCGIScripts !!! !!! HotCGIScripts !!! is offline
Guru Programmer
  
Join Date: Jun 2003
Location: USA
Posts: 47
Thanks: 0
Thanked 0 Times in 0 Posts
Cool
You have errors be course of missing comma and have unnecessary comma:

UPDATE cartHead SET randomKey = '24513114425506228', isGiftRegistry='Yes', WHERE idOrder = 69
Reply With Quote
  #3 (permalink)  
Old 09-02-03, 08:28 AM
geneane's Avatar
geneane geneane is offline
Newbie Coder
  
Join Date: Sep 2003
Location: The Carolinas
Posts: 59
Thanks: 0
Thanked 0 Times in 0 Posts
Wow that was quick..THANKS A MILLION!!!

That is from the error page, where is the error in the actual string?:

& "isGiftRegistry='" & "Yes" & "'," _

Where does the comma belong?
Reply With Quote
  #4 (permalink)  
Old 09-02-03, 07:39 PM
geneane's Avatar
geneane geneane is offline
Newbie Coder
  
Join Date: Sep 2003
Location: The Carolinas
Posts: 59
Thanks: 0
Thanked 0 Times in 0 Posts
Fixed!
Got it!

Thanks a million!
Reply With Quote
Reply

Bookmarks

« asp: checkboxes & multi-page form | save as... »

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes
Linear Mode Linear Mode

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
ASP Calendar..HELP...pls jimthepict ASP 1 07-31-03 05:01 PM
change my field in this example sal21 ASP 3 07-14-03 02:49 AM


All times are GMT -5. The time now is 03:24 PM.
vBulletin® Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.