Passing a Variable to SQL

Question

0.00/5 (No votes)

See more:

I have a variable that is an IP address. It is saved as text in my Access 2010 database. I am trying to run this query with ipSrc and the query always fails. My guess is that its seeing ipSrc as ipSrc and not as the actual IP address. I tried it with 'ipSrc' and just plain ipSrc and both reurn fail. Also tried ""ipSrc"", failed as well. This failed to. '&ipSrc'. Here is the statement.

C++

SQLCHAR* query = (SQLCHAR*)"SELECT tblIP.[IPAddress], tblIP.[IPType], tblIP.[IPStatus], tblIP.[IPMax] FROM tblIP WHERE tblIP.[IPAddress]= ipSrc AND tblIP.[IPType]=3 AND tblIP.[IPStatus]=1 AND tblIP.[IPMax]=0;";

and here is the definition of ipSrc.

C++

translate_ip(ip_header->source_ip, ipSrc);

Using printf it prints out as an actual IP address.

C++

printf("\n   Source      IP: %s", ipSrc);

Posted 24-Oct-11 7:37am

Member 7766180

Updated 24-Oct-11 7:46am

v3

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Espen Harlinn · Accepted Answer · 2011-10-24T08:06:00

Solution 1

[Updated]:

char buffer[1024] = {0,};
sprintf(buffer,"SELECT tblIP.[IPAddress], tblIP.[IPType], tblIP.[IPStatus], tblIP.[IPMax] FROM tblIP WHERE tblIP.[IPAddress]= %s AND tblIP.[IPType]=3 AND tblIP.[IPStatus]=1 AND tblIP.[IPMax]=0;",ipSrc);
SQLCHAR* query = (SQLCHAR*)buffer;

Use a single line for the sprintf call

Best regards
Espen Harlinn

Posted 24-Oct-11 8:06am

Espen Harlinn

Updated 24-Oct-11 10:25am

v2

Comments

Member 7766180 24-Oct-11 14:19pm

Tried it and it doesn't work. I'm runnig ansi on all of this and it's been working fine. If I put an actual ip address in like this '173.201.2.2' ,the code will run as predicted. I don't think it's seeing the ip address. I think it's seeing just ipSrc. It works in Access with an actual IP address.

Chuck O'Toole 24-Oct-11 17:55pm

The above solution is correct EXCEPT you need to wrap the %s with ' (single quote aka apostrophe) so it looks like '%s'. You really need to learn about formatting strings.

Member 7766180 24-Oct-11 19:08pm

Yes I do Chuck. Thank you as well!

Espen Harlinn 25-Oct-11 4:01am

A little glitch there on my part, so thanks for the note Chuck :)

Member 7766180 24-Oct-11 19:08pm

Thank you Espen, works great!

Espen Harlinn 25-Oct-11 4:01am

Excellent

RaisKazi 25-Oct-11 3:32am

5ing. :)

Espen Harlinn 25-Oct-11 4:02am

Thank you RaisKazi

Simon Bang Terkildsen 25-Oct-11 15:42pm

My 5

Amir Mahfoozi 2-Nov-11 9:20am

+5