Search results for query: *

The problem is when I select the IDS for Sandy, what it returns is a collection. How do I pass each of the values to the delete sql?

Itemid Sellername ----------- ----------- 1 Sandy 2 Sandy Bidid Buyerid Buyername Itemid ----------- ----------- ------------ ----------- 1 1 Mark 1 How do I write the sql statements to pass the the itemid 1 and 2 to bids so I can delete the related data from bids table given...

rsUsers.Open "bidders",Conn,adOpenForwardOnly,adLockOptimistic,adCmdTable Arguments are of the wrong type, are out of acceptable range, or are in conflict with one another. /AddUser.asp, line 40 MSSQL doesn't alllow retriving for whole tables?

Dim RSID Dim MaxID Set RSID = CreateObject("ADODB.Recordset") Set MaxID = CreateObject("ADODB.Recordset") MaxID = conn.Execute("Select MAX(bidderid)+1 from bidders") conn.Execute "Insert into bidders(bidderid,biddername, password, " _...

Problem solved. I had some typing mistakes that cause this.

eh? a friend of mine is using access and shes able to get it working. But I m using MSSQL Basically I m using TOP as my eof element. And I can't think of anyway to change the loop. Oh no..

Do Until RSCategory(&quot;parent_cat&quot;) = &quot;Top&quot; TempPath = &quot;<A HREF=&quot;&quot;&quot; & PathToPage _ & &quot;?CategoryName&quot; & RSCategory(&quot;parent_cat&quot;) & &quot;&quot;&quot;>&quot; _ & RSCategory(&quot;parent_cat&quot;) & &quot;<A> > &quot; &...

I have it in the later part of my asp file in the main html body codes.

I found a mistake in the sql statement I written should be Like instead of an equal sign. Somehow I m still having problems with the recordset and can't display the results

I found a mistake in the sql statement I written should be Like instead of an equal sign. Somehow I m still having problems with the recordset and can't display the results

Public Function GetAuctionItemsBySearch(SearchText, PathToPage) Set Conn = CreateObject(&quot;ADODB.Connection&quot;) Conn.ConnectionString = &quot;PROVIDER=SQLOLEDB;DATA SOURCE=&quot; & svrName _ & &quot;;INITIAL CATALOG=&quot; & dbName & &quot;;USER ID=&quot; &...

Public Function GetAuctionItemsBySearch(SearchText, PathToPage) Set Conn = CreateObject(&quot;ADODB.Connection&quot;) Conn.ConnectionString = &quot;PROVIDER=SQLOLEDB;DATA SOURCE=&quot; & svrName _ & &quot;;INITIAL CATALOG=&quot; & dbName & &quot;;USER ID=&quot; &...

I m using MS SQL. insert into auctionitem values (1,'wolfenstein','PC',20.00,1,'1991-07-03 00.00.00' ,1,'Newest PC Game') Server: Msg 242, Level 16, State 3, Line 1 The conversion of a char data type to a datetime data type resulted in an out-of-range datetime value. The statement has been...

insert into auctionitem values (1,'wolfenstein','PC',20.00,1,'1991-07-03 00.00.00' ,1,'Newest PC Game') Server: Msg 242, Level 16, State 3, Line 1 The conversion of a char data type to a datetime data type resulted in an out-of-range datetime value. The statement has been terminated.

Insert Into auctionitem values (1,'wolfenstein','PC',20.00,1,Jul 3 1991 12:00AM ,1,'Newest PC Game') Line 2: Incorrect syntax near '3'. This is how i set it up CREATE TABLE [auctionitem] ( [auctionitem_id] [int] NOT NULL , [productname] [varchar] NOT NULL , [category_name]...

33333