 |
| SQL Language SQL Language discussions not specific to a particular RDBMS program or vendor. |
Welcome to the p2p.wrox.com Forums.
You are currently viewing the SQL Language section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
|
|
|
|
March 1st, 2006, 02:03 PM
|
|
Friend of Wrox
|
|
Join Date: May 2005
Posts: 189
Thanks: 0
Thanked 0 Times in 0 Posts
|
|
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
__________________
Internet has become favorable with that tool...thank you Tim Berners-Lee!
|
|
March 1st, 2006, 08:53 PM
|
|
Wrox Technical Editor
|
|
Join Date: Dec 2005
Posts: 271
Thanks: 0
Thanked 0 Times in 0 Posts
|
|
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
|
|
March 1st, 2006, 08:55 PM
|
|
Friend of Wrox
|
|
Join Date: Jan 2004
Posts: 1,870
Thanks: 12
Thanked 20 Times in 20 Posts
|
|
mmmmm
;;;expected identificator
doenst sound like an error to me. is this a typo?
Wind is your friend
Matt
|
|
March 4th, 2006, 11:51 PM
|
|
Friend of Wrox
|
|
Join Date: Nov 2003
Posts: 1,348
Thanks: 0
Thanked 5 Times in 5 Posts
|
|
Sounds like an ASP error, not a SQL error
|
|
March 5th, 2006, 06:12 PM
|
|
Friend of Wrox
|
|
Join Date: Jan 2004
Posts: 1,870
Thanks: 12
Thanked 20 Times in 20 Posts
|
|
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
|
|
March 6th, 2006, 01:16 AM
|
|
Friend of Wrox
|
|
Join Date: Nov 2003
Posts: 1,348
Thanks: 0
Thanked 5 Times in 5 Posts
|
|
????
|
|
March 6th, 2006, 01:18 AM
|
|
Friend of Wrox
|
|
Join Date: Jan 2004
Posts: 1,870
Thanks: 12
Thanked 20 Times in 20 Posts
|
|
Which part requires explanation?
Wind is your friend
Matt
|
|
March 6th, 2006, 01:26 AM
|
|
Friend of Wrox
|
|
Join Date: Nov 2003
Posts: 1,348
Thanks: 0
Thanked 5 Times in 5 Posts
|
|
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.
|
|
March 6th, 2006, 01:36 AM
|
|
Friend of Wrox
|
|
Join Date: Jan 2004
Posts: 1,870
Thanks: 12
Thanked 20 Times in 20 Posts
|
|
;;;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
|
|
March 6th, 2006, 01:40 AM
|
|
Friend of Wrox
|
|
Join Date: Nov 2003
Posts: 1,348
Thanks: 0
Thanked 5 Times in 5 Posts
|
|
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..
|
|
|
