Database output not showing up. 
Author Message
 Database output not showing up.

Can anyone tell me why the following is not working as no error comes up on
screen.

I'd added ;
Response.Write("hello!");
in the following code and there is no result from this old chestnut.

The code works in VBScript and is hacked from a database already working but it
needs to be done in JavaScript.

Many thanks,

Richard.

---------------------------------------------------------------------

<%

var dbConn = Server.CreateObject("ADODB.Connection");
dbConn.Open("DSN=xxx-xxxx");
var conn = Server.CreateObject("ADODB.Recordset");
var strSQL = "Select * from PLACES";
var rs = conn.Execute(strSQL);

rs.moveFirst();

Response.Write(rs.street);
Response.Write("hello!");

rs.close();

%>
-----------------------------------------------------------



Mon, 21 Jul 2003 19:51:34 GMT  
 Database output not showing up.
Hi

Response.Write( rs("fieldName") )

--
--
Best Regards
  Vidar Petursson
 ==============================
   Microsoft Internet, Client, SDK MVP
 ==============================
 http://www.icysoft.com
 http://www.dna.is



 ==============================
  No matter where you go there you are
 ==============================
--


Quote:
> Can anyone tell me why the following is not working as no error comes up
on
> screen.

> I'd added ;
> Response.Write("hello!");
> in the following code and there is no result from this old chestnut.

> The code works in VBScript and is hacked from a database already working
but it
> needs to be done in JavaScript.

> Many thanks,

> Richard.

> ---------------------------------------------------------------------

> <%

> var dbConn = Server.CreateObject("ADODB.Connection");
> dbConn.Open("DSN=xxx-xxxx");
> var conn = Server.CreateObject("ADODB.Recordset");
> var strSQL = "Select * from PLACES";
> var rs = conn.Execute(strSQL);

> rs.moveFirst();

> Response.Write(rs.street);
> Response.Write("hello!");

> rs.close();

> %>
> -----------------------------------------------------------



Mon, 21 Jul 2003 22:21:40 GMT  
 
 [ 2 post ] 

 Relevant Pages 

1. Re Database output not showing up

2. Creating ADO recordset w/o database .Append not working correctly IIS5 win2000 Prof not .Net

3. Showing posts from database

4. One for the experts - show image from a database

5. Show OLE Object from Access Database

6. Showing database results as a hyperlink using Vbscript

7. Postscript Output from Database?

8. Ranking ASP Database Output...

9. OutPut to Database

10. window.open does not show content

11. ghostview not showing pages

12. DIV not showing over combo

 

 
Powered by phpBB® Forum Software