[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re[2]: [cobalt-users] ASP and MYSQL


I had the same problem, and your code has helped solve my DNS
connection to the MySQL database.

Is it possible to send me the continuation of the code to show me how to
execute queries on the database? The problem right now is I can no longer use
my_conn.execute (or something similar) to execute the query anymore. It's
giving me a runtime error.


I just use some DreamweaverMX boilerplate

(Note: connnMyConnection.asp has the connection string info, nothing else)

<!--#include virtual="/Connections/connMyConnection.asp" -->

<%
set Recordset1 = Server.CreateObject("ADODB.Recordset")
Recordset1.ActiveConnection = connMyConnection
Recordset1.Source = "SELECT * FROM tablename"
Recordset1.CursorType = 0
Recordset1.CursorLocation = 2
Recordset1.LockType = 3
Recordset1.Open()
Recordset1_numRows = 0
%>

Brian

--
Brian M. Rahill
President
RainStorm, Inc.
http://www.rainstormconsulting.com
"Designing Strategies for Internet Success."
brian@xxxxxxxxxxxxxxxx
Phone: 207-866-3908
Fax: 207-866-0297