MySQL Forums
Forum List  »  Newbie

Re: SQL + string
Posted by: Phillip Ward
Date: April 17, 2023 07:52AM

Short Answer:

rs_MSExcel_01!abonnee  !=  "rs_MSExcel_01!abonnee"

This might work:

Strng2 = rs_MSExcel_01!abonnee
StrSQL_00 = "INSERT INTO db_00 (" & Strng1 & ") VALUES (" & Strng2 & ")"

Be warned: If the value in abonnee is not numeric, you're on the verge of creating you're very own SQL Injection Attack.
At the very least, you would have to quote the SQL literal.

StrSQL_00 = "INSERT INTO db_00 (" & Strng1 & ") VALUES ( '" & Strng2 & "' )"
                                                        ^              ^
At best, you [really] should investigate Parameterised Queries.

I'm slightly worried by that table name as well.
It hints towards your having "db_01", "db_02", "db_793", etc., all with the same structure.
The "Table-per-Thing" Model almost always breaks down as the number of Things increases and you can get just as good performance from a single table with all the same columns, plus a "Thing" identifier.

Regards, Phill W.

Options: ReplyQuote

Written By
April 10, 2023 05:36AM
Re: SQL + string
April 17, 2023 07:52AM

Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.