Enter Keywords:
1 - 10 of 28(0.033 seconds)
Sort By:
 
I want to use  a parameterized query to retrieve data. I received error below. I have three textboxes. First is a TranNumber, second is Address, third is City and State. This is what I put in s...
Zones: MS Visual BasicDate Answered: 04/22/2006 Rating: 7.6 Views: 0
I have a parameterized Query that I want to execute in ASP.NET but it is not returning any records (but not giving me any errors either).  Here is the relevent code:       '************** START ...
Zones: ASP.Net Programming, MS SQL ...Date Answered: 06/06/2007 Rating: 6.6 Views: 0
How to use DAO (CDaoRecordset) to call a parameterized query in MS Access?  Can this be done?  CDaoRecordset doesn't seem to work on predifined queries in Access, only on whole tables.  Have previo...
Zones: Windows MFCDate Answered: 10/04/1998 Rating: 8.0 Views: 0
I have been searching the net for a good example that can provide the complete code, including opening the database connection and calling a pre defined query (with parameters) within the database ...
Zones: ASPDate Answered: 05/10/2004 Rating: 8.4 Views: 0
Hi experts, this is a continuation of an previous question http://www.experts-exchange.com/Programming/Programming_Languages/Dot_Net/ASP_DOT_NET/Q_21390327.html --------------------------- ...
Zones: ASP.Net ProgrammingDate Answered: 04/15/2005 Rating: 8.6 Views: 0
Hi experts, Would you look at two different INSERT Queries and help me find out why one works and other does not. first one that works ========================================== Dim Cmd2 As...
Zones: ASP.Net ProgrammingDate Answered: 04/15/2005 Rating: 8.2 Views: 0
How do I do parameter query in MsSQL? It is working in Oracle.       Set objDB = Server.CreateObject("ADODB.Connection")       objDB.Open dbConnectionString       Set objCmd = Server.CreateObject("ADODB....
Zones: ASPDate Answered: 03/07/2006 Rating: 9.2 Views: 0
if I were using a MS SQL table I could create a parameterized query by saying: SELECT     OrderID, CustomerID, RepresenitiveID, OrderDate FROM         [Order] WHERE     (CustomerID = @Customer...
Zones: MS Visual BasicDate Answered: 03/06/2006 Rating: 9.6 Views: 0
I am receiving the below error when running the below query in Query Analyzer. I am not good at all with SQL and am hoping someone can expalin to me how I can make this snytax correct for use as a ...
Zones: SQL Syntax, MS SQL ServerDate Answered: 08/14/2007 Rating: 8.6 Views: 0
The query (qryNameOfTheQuery) SQL looks like this (where prmUser and prmTimeInterval are also the name of two text boxes on the form): PARAMETERS prmUser Text ( 255 ), prmTimeInterval Long; SELEC...
Zones: Access Coding/Macros, MS A...Date Answered: 03/11/2008 Rating: 9.5 Views: 0