Solved

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

Posted on 2008-10-31
3
203 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
Comment Utility
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
Comment Utility
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
Comment Utility
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

Do You Know the 4 Main Threat Actor Types?

Do you know the main threat actor types? Most attackers fall into one of four categories, each with their own favored tactics, techniques, and procedures.

Join & Write a Comment

Suggested Solutions

Title # Comments Views Activity
Contant UI messages in .NET 1 40
Javascript newbie 5 38
Server error in 'XXXXXXXX' application. 12 47
getting id from database 5 24
In this Article, I will provide a few tips in problem and solution manner. Opening an ASPX page in Visual studio 2003 is very slow. To make it fast, please do follow below steps:   Open the Solution/Project. Right click the ASPX file to b…
International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
Illustrator's Shape Builder tool will let you combine shapes visually and interactively. This video shows the Mac version, but the tool works the same way in Windows. To follow along with this video, you can draw your own shapes or download the file…
This video shows how to remove a single email address from the Outlook 2010 Auto Suggestion memory. NOTE: For Outlook 2016 and 2013 perform the exact same steps. Open a new email: Click the New email button in Outlook. Start typing the address: …

744 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