p2p.wrox.com Forums

p2p.wrox.com Forums (http://p2p.wrox.com/index.php)
-   SQL Language (http://p2p.wrox.com/forumdisplay.php?f=100)
-   -   What is missing? (http://p2p.wrox.com/showthread.php?t=39228)

grstad March 1st, 2006 02:03 PM

What is missing?
 
Hallo!

What is ment by this error-message

expected identificator
objrs."UPDATE produkter SET hoyde = 'hoyde', haar = 'haar', oye = 'oye', vekt = 'vekt' WHERE e_post='Session("epost")'", kobling, adopenforwardonly, adlockoptimistic, adcmdtable
-----^
Mvh grstad


adam_kahtava March 1st, 2006 08:53 PM

Could you include the complete error message?
What language / technology are you using?

It looks as though you are trying to use a SQL UPDATE statement on a record set.
RecordSets are typically modified through Methods(.Update()).
If you want to perform an UPDATE through SQL you'll have to use an .Execute, .ExecuteQuery or similar method.

Here's a link on updating RecordSets with ASP:
http://www.stardeveloper.com/article...0032801&page=1

- A.Kahtava

mat41 March 1st, 2006 08:55 PM

mmmmm

;;;expected identificator
doenst sound like an error to me. is this a typo?

Wind is your friend
Matt

jbenson001 March 4th, 2006 11:51 PM

Sounds like an ASP error, not a SQL error


mat41 March 5th, 2006 06:12 PM

There is no such ASP error. How to get a number on google ranking, make something up. Do a search for 'expected identificator' you are number one.

Wind is your friend
Matt

jbenson001 March 6th, 2006 01:16 AM

????


mat41 March 6th, 2006 01:18 AM

Which part requires explanation?

Wind is your friend
Matt

jbenson001 March 6th, 2006 01:26 AM

Bascially the whole thing except that it is not an ASP error. don't understand your following comment. I suggested it was an ASP error becuase the poster shows the error poinging to asp code.

mat41 March 6th, 2006 01:36 AM

;;;How to get a number on google ranking, make something up. Do a search for 'expected identificator' you are number one.

I guess you could call this my sense of humor. We all know how hard it is to get a number one google ranking. Do a search for 'expected identificator' this very post is number one - because its not an error, is probably a typo and there is no such thing.

Applogies for getting a bit left of center, straying from the post and chucking a bit of humor out there. If you have ever tryed to target keywords in the attempt to get the best possible google ranking (number one I guess) you would find this s bit funny.

Have a nice day

Wind is your friend
Matt

jbenson001 March 6th, 2006 01:40 AM

Ahh i see.. LOL.. well it is good to have a sense of humor.. I didn't even realize that it was a typo till you pointed it out and i tried to Gppgle it..


mat41 March 6th, 2006 01:48 AM

LOL indeed. In my experience many coders dont have one or if they do can tend to be a bit dry.

grstad - Sorry for molesting your post. In future post the full un friendly http error. I am asuming your were supposed to post 'expected identifier' as your error?

Wind is your friend
Matt

adam_kahtava March 6th, 2006 01:53 AM

LOL.. Too much.. :)

- A.Kahtava


All times are GMT -4. The time now is 10:15 PM.

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.