Solved

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

Posted on 2008-10-31
3
216 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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

MS Dynamics Made Instantly Simpler

Make Your Microsoft Dynamics Investment Count  & Drastically Decrease Training Time by Providing Intuitive Step-By-Step WalkThru Tutorials.

Question has a verified solution.

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

In an ASP.NET application, I faced some technical problems. In this article, I list them out and show the solutions that I found.  I hope it will be useful. Problem: After closing a pop-up window, the parent page should be refreshed automaticall…
User art_snob (http://www.experts-exchange.com/M_6114203.html) encountered strange behavior of Android Web browser on his Mobile Web site. It took a while to find the true cause. It happens so, that the Android Web browser (at least up to OS ver. 2.…
In this video, viewers are given an introduction to using the Windows 10 Snipping Tool, how to quickly locate it when it's needed and also how make it always available with a single click of a mouse button, by pinning it to the Desktop Task Bar. Int…
There's a multitude of different network monitoring solutions out there, and you're probably wondering what makes NetCrunch so special. It's completely agentless, but does let you create an agent, if you desire. It offers powerful scalability …

632 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