For Programmers: Free Programming Magazines  


Home > Archive > PHP SQL > April 2004 > Passing a VB.Net Variable to an SQL Statement









You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

 

Author Passing a VB.Net Variable to an SQL Statement
J French

2004-04-11, 9:31 am

I am passing a string variable from a program written in VB.Net to a SELECT
statement. The variable name is Cat1. The code I have used is:

"DECLARE @Find nvarchar(30) SET @Find = ' + Cat1 + ' etc.

" WHERE Master.nameLast LIKE @Find"

This doesn't work. Searching my books has not helped either. Please, how do
I do it ?

John




Sponsored Links







Also available: Server administration forum archive | Web Design forum archive | Software forum archive | Hardware reviews archive

Copyright 2008 codecomments.com