Returning SQL query results as a string

[ants211]

Hi, I want to create a string i.e. strFaultid as a result of an sql query.

The SQL returns a value dependent on the input of the user in the previous form. The SQL statement is as follows:

Select faultid from fault where category=""&strCategory&"" and category_sub=""&strCategory_sub&""

The category and category_sub strings are passed in from the previous form. I would like to create a faultid string as a result of this query so I can populate a table with the value.

Any help is appreciated.

 

[JamesLean]

Are you only expecting one faultid to be returned or several? If it is only one then you can use something like this:

'(open connection called conn)

strSQL = "SELECT faultid FROM fault WHERE category = '" & strCategory & "' AND category_sub = '" & strCategory_sub & "'"

rs = conn.Execute(strSQL)

strFaultID = rs("faultid")

Or do you expect multiple values to be returned from the query? if so, what format do you want your string to take?

 

[onpnt]

try using the CStr function ---------------------------------------
{ str = "sleep is good for you. sleep gives you the energy you need to function";
ptr = /sleep/gi;Nstr = str.replace(ptr,"coffee"alert(Nstr); }
---------------------------------------
for the best results to your questions: FAQ333-2924

http://www.onpntwebdesigns.com