Solved

output my sql query to the web page for debug / testing

Posted on 2008-10-31
3
204 Views
Last Modified: 2012-05-05
hello,

i have a sql query that takes i want to pass values from form field inputs (Session, MachineName, JobType). If i hard code the values in the query it works fine, its just not displaying anything when i try ti read in from the form fields.

in php ive been able to print the sql query with all the variables, etc. to the screen to verify im getting the correct data. how would i go about doing this in asp.net?

Thanks


example query below


select * from TableName
 

WHERE     

(dbo.tbl_Datasheets_Machines_DataSet.Site LIKE '%' + ? + '%') 

AND (dbo.tbl_Datasheet_Users_DataSet.Session = ?) 

AND (dbo.tbl_Datasheet_Positions_DataSet.Position LIKE '%' + ? + '%') 

AND (dbo.tbl_Datasheets_Customer_DataSet.User_Type = 'Advanced')
 

ORDER BY dbo.tbl_Datasheets_Machines_DataSet.Machine_Name ASC">
 

 

        

        </script>

    

        <SelectParameters>

        <asp:ControlParameter ControlID="MachineName" Name="Machine_Name" 

            PropertyName="Text" Type="String" />

        <asp:ControlParameter ControlID="Position" Name="Position" PropertyName="Text" 

            Type="String" />

        <asp:ControlParameter ControlID="SessionTime" Name="Session" 

            PropertyName="Text" Type="String" />

    </SelectParameters>

Open in new window

0
Comment
Question by:nriddock
  • 2
3 Comments
 
LVL 3

Expert Comment

by:ahll
ID: 22853751
Hi...I'm a little confused. Your code is not complete.

Anyway..if thats is the exacu query you are using, you have to especify the paramneters in there. it should look like this:

select * from TableName

 

WHERE     

(dbo.tbl_Datasheets_Machines_DataSet.Site LIKE '%' + @MachineName+ '%') 

AND (dbo.tbl_Datasheet_Users_DataSet.Session = @Session) 

AND (dbo.tbl_Datasheet_Positions_DataSet.Position LIKE '%' + @Position + '%') 

AND (dbo.tbl_Datasheets_Customer_DataSet.User_Type = 'Advanced')

 

ORDER BY dbo.tbl_Datasheets_Machines_DataSet.Machine_Name ASC

Open in new window

0
 

Author Comment

by:nriddock
ID: 22853829
i appreciate the updated code...do you know of a way to output the sql query as its executed so i can debug/test.

ie:

<pseduocode>

echo "$sqlQuery;"
</pseudocode>

Would output on the screen

select * from TableName WHERE    
(dbo.tbl_Datasheets_Machines_DataSet.Site LIKE NY107A100)
AND (dbo.tbl_Datasheet_Users_DataSet.Session = AM)
AND (dbo.tbl_Datasheet_Positions_DataSet.Position LIKE Manager)
AND (dbo.tbl_Datasheets_Customer_DataSet.User_Type = Advanced)
 
ORDER BY dbo.tbl_Datasheets_Machines_DataSet.Machine_Name ASC
0
 
LVL 3

Accepted Solution

by:
ahll earned 500 total points
ID: 22853942
What happened with that code?...Did it work? You might to play with the quotes too.
Could you paste the whole DataSourde code?...It would help a lot.

If you are using a SQLDataSource I dont know how to see the whole query with the parameters already included.
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Lots of people ask this question on how to extend the “MembershipProvider” to make use of custom authentication like using existing database or make use of some other way of authentication. Many blogs show you how to extend the membership provider c…
Introduction This article shows how to use the open source plupload control to upload multiple images. The images are resized on the client side before uploading and the upload is done in chunks. Background I had to provide a way for user…
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.
Sending a Secure fax is easy with eFax Corporate (http://www.enterprise.efax.com). First, just open a new email message. In the To field, type your recipient's fax number @efaxsend.com. You can even send a secure international fax — just include t…

895 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now