Comment utiliser une variable dans une clause WHERE ?

0
747

1. don’t set the variable in the script to an empy value (let Myvar =  »;)

 

2. use right notation in Where Clause:

 

WHERE (Field1 = $(Myvar));  // on numeric value

 

WHERE (Field1 = ‘$(Myvar)’);  // on string value

LEAVE A REPLY

Please enter your comment!
Please enter your name here