Searching database problem

[HallMonitor89]

Having an issue. Trying to create an ASP search page that queries SQL
2k database based on some set and some variable criteria. The problem,
I think, lies in how I am presenting the SQL statement to the SQL
server. Thanks in advance.

Code follows:
=============

noodle="SELECT Customers.[Company Name], Customers.State,
Schedule.PurchaseType, Schedule.[Equipment Amount] " & _
"FROM Customers INNER JOIN Schedule ON Customers.ID = Schedule.ID " & _
"WHERE (Schedule.PurchaseType) = '" & rEquipmentType & "' "

set WhataRecordset = cn.execute (noodle)
do While Not WhataRecordset.EOF
Response.Write("<tr><td>" & [Customers].[Company Name] & "</td><td>" &
[Customers].[State] & "</td><td>" & _
[Schedule].[PurchaseType] & "</td><td>" & [Schedule].[Equipment Amount]
& "</td></tr>")

WhataRecordset.MoveNext
loop
WhataRecordset.close

*** Sent via Developersdex [url]http://www.developersdex.com[/url] ***
Don't just participate in USENET...get rewarded for it!

[Ray at]

It usually helps to say what error you're getting.
<%
do While Not WhataRecordset.EOF
Response.Write("<tr><td>" & WhataRecordset.Fields.Item(0).Value &
"</td><td>" & WhataRecordset.Fields.Item(1).Value & "</td><td>" & _
WhataRecordset.Fields.Item(2).Value & "</td><td>" &
WhataRecordset.Fields.Item(4).Value & "</td></tr>")
%>

You don't use the column names in your ASP code like that. You reference
the columns within the recordset object, either by name, or by numeric
index, starting at 0. In this recordset, index 0 is Company Name, 1 is
State, and so on.

Also, since you're in the beginning of things, assumingly, you should rename
your columns in your database and ditch the spaces...

Ray at work




"HallMonitor89" <nospam@novirus.com> wrote in message
news:ea9HX9CxDHA.2520@TK2MSFTNGP10.phx.gbl...

>
>
> Having an issue. Trying to create an ASP search page that queries SQL
> 2k database based on some set and some variable criteria. The problem,
> I think, lies in how I am presenting the SQL statement to the SQL
> server. Thanks in advance.
>
> Code follows:
> =============
>
> noodle="SELECT Customers.[Company Name], Customers.State,
> Schedule.PurchaseType, Schedule.[Equipment Amount] " & _
> "FROM Customers INNER JOIN Schedule ON Customers.ID = Schedule.ID " & _
> "WHERE (Schedule.PurchaseType) = '" & rEquipmentType & "' "
>
> set WhataRecordset = cn.execute (noodle)
> do While Not WhataRecordset.EOF
> Response.Write("<tr><td>" & [Customers].[Company Name] & "</td><td>" &
> [Customers].[State] & "</td><td>" & _
> [Schedule].[PurchaseType] & "</td><td>" & [Schedule].[Equipment Amount]
> & "</td></tr>")
>
> WhataRecordset.MoveNext
> loop
> WhataRecordset.close
>
> *** Sent via Developersdex [url]http://www.developersdex.com[/url] ***
> Don't just participate in USENET...get rewarded for it!