SQL statement Error

•

What is DaniWeb IT Discussion Community?

You're currently browsing the ASP section within the Web Development category of DaniWeb, a massive community of 429,966 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 2,607 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.

Join our community!

Please support our ASP advertiser: Lunarpages ASP Web Hosting

Thread Tools Display Modes

Views: 982 | Replies: 2 | Solved

•

Join Date: Jul 2005

Posts: 35

Reputation: k_en is an unknown quantity at this point

Rep Power: 4

Solved Threads: 0

k_en

Offline

Light Poster

SQL statement Error

Mar 21st, 2007

i can't see where is the Invalid character with the SQL statement below. i can't see where i miss any character or i added extra characters.

mySQL = "UPDATE table SET col1 = '"_& rA & "', col2 = " & rB & ", col3 = " & rC & ", col4 = " & rD & ", col5 = " & rE ", col6 = " & rF & " WHERE primaryKey = '" & primary "'"

•

Join Date: Mar 2007

Location: Alaska

Posts: 9

Reputation: GeneM is an unknown quantity at this point

Rep Power: 0

Solved Threads: 1

GeneM

Offline

Newbie Poster

Re: SQL statement Error

Mar 21st, 2007

possible double quotes at end, but i missed it, sorry.

Last edited by GeneM : Mar 21st, 2007 at 4:15 pm. Reason: missread the statement

•

Join Date: Mar 2007

Posts: 1

Reputation: Mabolo is an unknown quantity at this point

Rep Power: 0

Solved Threads: 0

Mabolo

Offline

Newbie Poster

Re: SQL statement Error

Mar 23rd, 2007

mySQL = "UPDATE table SET col1 = '"_& rA & "', col2 = " & rB & ", col3 = " & rC & ", col4 = " & rD & ", col5 = " & rE & ", col6 = " & rF & " WHERE primaryKey = '" & primary "'"