Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: E3
  • Content: Threads
  • Order by date
  1. E3

    Stored procedure help...

    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...
  2. E3

    Microsoft SQL Users.

    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?
  3. E3

    Quotation help in VB

    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, " _...
  4. E3

    Just plain weird..

    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; &...
  5. E3

    recordset lost? sql?

    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; &...
  6. E3

    RecordSet Lost...

    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; &...
  7. E3

    How to add a datetime field in sql7?

    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]...

Part and Inventory Search

Back
Top