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
Solved

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

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

Networking for the Cloud Era

Join Microsoft and Riverbed for a discussion and demonstration of enhancements to SteelConnect:
-One-click orchestration and cloud connectivity in Azure environments
-Tight integration of SD-WAN and WAN optimization capabilities
-Scalability and resiliency equal to a data center

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Obtain cell value using column ID in DataGrid using VB.NET 2 25
ASP.NET Content Page 3 25
Please explain purpose of GZIP 4 34
Easy filter aspnet 2 24
Sometimes in DotNetNuke module development you want to swap controls within the same module definition.  In doing this DNN (somewhat annoyingly) swaps the Skin and Container definitions to the default admin selections.  To get around this you need t…
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 …
This video shows how to use Hyena, from SystemTools Software, to bulk import 100 user accounts from an external text file. View in 1080p for best video quality.
The Email Laundry PDF encryption service allows companies to send confidential encrypted  emails to anybody. The PDF document can also contain attachments that are embedded in the encrypted PDF. The password is randomly generated by The Email Laundr…

839 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