Solved

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

Posted on 2008-10-31
3
205 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

Netscaler Common Configuration How To guides

If you use NetScaler you will want to see these guides. The NetScaler How To Guides show administrators how to get NetScaler up and configured by providing instructions for common scenarios and some not so common ones.

Question has a verified solution.

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

Today is the age of broadband.  More and more people are going this route determined to experience the web and it’s multitude of services as quickly and painlessly as possible. Coupled with the move to broadband, people are experiencing the web via …
The article shows the basic steps of integrating an HTML theme template into an ASP.NET MVC project
In a recent question (https://www.experts-exchange.com/questions/28997919/Pagination-in-Adobe-Acrobat.html) here at Experts Exchange, a member asked how to add page numbers to a PDF file using Adobe Acrobat XI Pro. This short video Micro Tutorial sh…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

770 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