Search results for query: *

From http://us4.php.net/manual/en/function.mysql-real-escape-string.php: mysql_real_escape_string -- Escapes special characters in a string for use in a SQL statement, taking into account the current charset of the connection. It's written with MySQL in mind. I'm specifically looking for a VB...

Hello, Does a VisualBasic equivalent to the PHP function mysql_escape_string() exist? Preferably one that takes care of characters special according to MS SQL Server 2K. Through my searching I found one function that takes care of single quotes, but nothing else. Thanks!

Hi Bob, First, thanks for your reply. This morning I tried different queries and shifting things around and noticed it wasn't the JOIN statement that kept the query from running, but the fields with parentheses. I tried putting square brackets around only the field name--and now it works...

Hello, I have an Access database which links to tables on an MS SQL Server. It has a query which pulls together information from three different tables. Two of the tables are in one database; the third is in another. The query is supposed to grab the first full set of information it finds for a...

Great! Thank you for the explanation. Ben

Thank you very much, Duane! Your help is greatly appreciated. Could you please explain why this method works? I don't understand why Abs(Sum(expr)) returns the number of records matching expr. Thanks again, Ben

I'm having the same problem as AMW1106. I have a field I would like to count only when it is greater than zero. Using the following generates #Error instead of a count: =DCount("[Lbs_Sampled]","ONP Quality Statistics for Supplier (BJ - 7/24/03)","[Lbs_Sampled]>0")...

I have exactly this same problem. I was pleasantly surprised to see that someone had already asked my question; unfortunately nobody has answered it yet. :-( Does anyone know how to accomplish this?