proper formatting for this variable

[John117]

$sQuery = 'SELECT User_Name FROM Users WHERE User_Name="David"'

Replace David with variable $UserName

$sQuery = 'SELECT User_Name FROM Users WHERE User_Name= $UserName' -nope tried a few ways, none working

Anyone spot my mistake?

[Jos]

$sQuery = 'SELECT User_Name FROM Users WHERE User_Name= ' & $UserName

[Monamo]

$sQuery = 'SELECT User_Name FROM Users WHERE User_Name=' & $UserName

[John117]

Thanks for the reply!

I tried that one earlier, doesnt seem to like it. This is an SQL query if that helps . . .

[Monamo]

Is it possibly an issue with quotation marks?

That is, considering the need for double ("") if you want the quotes to be passed as part of the string:

$UserName = ""David""

[John117]

error looks right but does not include " around the userid . . . could be causing it . . . how would you insert " around it """ will not insert the text "

[Jos]

when double quotes are needed just do:

$sQuery = 'SELECT User_Name FROM Users WHERE User_Name="' & $UserName & '"'

[John117]

Solved . . .

$sQuery = 'SELECT User_Name FROM Users WHERE User_Name=' & '"' & $UserName & '"'

Thanks for the help!

[Monamo]

$UserName = '"David"'
$sQuery = 'SELECT User_Name FROM Users WHERE User_Name=' & $UserName
MsgBox(0,"",$sQuery)

My mistake on the above entry, should have used single (') around the doubles(")

[John117]

$UserName = '"David"'
$sQuery = 'SELECT User_Name FROM Users WHERE User_Name=' & $UserName
MsgBox(0,"",$sQuery)

My mistake on the above entry, should have used single (') around the doubles(")

Thanks, works well

[weaponx]

To avoid confusion with quotation marks I like to use StringFormat

$sQuery = StringFormat ( "SELECT User_Name FROM Users WHERE User_Name='%s'", $UserName)