Wrox Home  
Search P2P Archive for: Go

  Return to Index  

asp_databases thread: How to display only the data that I want?


Message #1 by Lizawati Bakri <LIZA_B@e...> on Wed, 14 Feb 2001 11:12:36 +0800
This message is in MIME format. Since your mail reader does not understand

this format, some or all of this message may not be legible.



------_=_NextPart_001_01C09633.FD336038

Content-Type: text/plain;

	charset="iso-8859-1"



I have a program to display data that I want but i dont know how to write

the syntax ,and where to put it ..

 This is my program :



Set DataConn = Server.CreateObject("ADODB.Connection")

DataConn.ConnectionTimeout = 15

DataConn.CommandTimeout = 30

DataConn.Open "DSN=CarCustomize"

Set cmdTemp = Server.CreateObject("ADODB.Command")



Set rsnotice = Server.CreateObject("ADODB.Recordset")

cmdTemp.CommandText = "SELECT * FROM `notice`  " 

cmdTemp.CommandType = 1

Set cmdTemp.ActiveConnection = DataConn

rsnotice.Open cmdTemp, , 1, 3 



 

your help is most welcome







  Return to Index