The error appears to begin at the line rs.Open sql, conn, I suspect that I am using mixed nomenclature?
<% Set Cn = Server.CreateObject("ADODB.Connection")
Set RS = Server.CreateObject("ADODB.R...
http://www.experts-exchange.com/Web_Development/Web_Languages-Standards/ASP/Q_20845603.htm...
Zones:
ASPDate Answered: 01/19/2004 Rating: 8.4 Views: 0
I'm getting some values from an Access db, and I need to create custom URLs based on one of the field names. The problem is that the particular field I will be using can have spaces and apostrophe...
http://www.experts-exchange.com/Web_Development/Web_Languages-Standards/ASP/Q_22994325.htm...
Zones:
ASP,
SQL SyntaxDate Answered: 11/30/2007 Rating: 9.9 Views: 0
Hello,
I am having a problem with the data I am trying to retrieve...
What I would like to do is find the Average (DATEDIFF) between the DateOpened and DateClosed columns in the database. Al...
http://www.experts-exchange.com/Programming/Languages/Visual_Basic/VB_Script/Q_23266744.ht...
I need to write a stored procedure that automatically queries a database with the following query and store the data into a new table. It has to do this continuously every 30 mins or 60 mins.
Qu...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SQL-Server-2005/Q_2346...
How do we create a form that enters multiple records of (eg) books that a user has into a table? As example, table tblBooks contains a list of books with details, tblUsers has list of people with t...
http://www.experts-exchange.com/Web_Development/Web_Languages-Standards/ASP/Q_23484347.htm...
I need some help adding up duplicate items in a table column.
I have the following statement:
Dim conn, cat
Set conn = Server.CreateObject("ADODB.Connection")
conn.Open ("Provider=Micro...
http://www.experts-exchange.com/Web_Development/Web_Languages-Standards/ASP/Q_23672694.htm...
Zones:
ASPDate Answered: 08/23/2008 Rating: 8.6 Views: 0
angelIII helped me earlier with this:
rs.Open "SELECT [STOCK NO], YEAR, MFG, BRAND, MODEL, DCOUNT(""*"", ""STOCK"", ""MODEL='"" & MODEL & ""'"") AS AVAILABLE, PRICE, LOT, TYPE, [WEB PRICE] FROM ...
http://www.experts-exchange.com/Web_Development/Web_Languages-Standards/ASP/Q_23673092.htm...
Zones:
ASPDate Answered: 08/25/2008 Rating: 9.3 Views: 0
Hi, I'm trying to create an asp webform that when completed by a user and submitted will insert the form field contents as a record into a sql server 2k database. For some reason I'm getting a syn...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SQL-Server-2005/Q_2395...
I uploaded a database on to an already working site. The code is fine, everything is in tact, and yet, for some unknown reason, I'm getting an error message that says that the "...operation must us...
http://www.experts-exchange.com/Web_Development/Web_Languages-Standards/ASP/Q_24046244.htm...
Zones:
ASPDate Answered: 01/17/2009 Rating: 7.8 Views: 0
Hi there,
I need some code in asp (vbscript) that allows me to move values from one table to another table.
I have two tables contacts and mycontacts. when i click on the button 'Move' from m...
http://www.experts-exchange.com/Web_Development/Web_Languages-Standards/ASP/Q_24126049.htm...
Zones:
ASP,
SQL SyntaxDate Answered: 02/16/2009 Rating: 7.8 Views: 0
