p2p.wrox.com Forums

Need to download code?

View our list of code downloads.


  Return to Index  

proasp_codeclinic thread: PopUp menu generated by ASP


Message #1 by "Richard" <dick@h...> on Fri, 27 Apr 2001 03:13:17
> If you want to follow Charles' suggestion, change adCmdTable to adCmdText
> otherwise you'll get a ADODB 800a0bb9 error. :-)

    Whoops!  My Microsoft Natural Keyboard hates me! -=]

? Chuck

----- Original Message -----
From: "Ken Schaefer" <ken@a...>
To: "Code Clinic" <proasp_codeclinic@p...>
Sent: Sunday, April 29, 2001 7:57 PM
Subject: [proasp_codeclinic] Re: PopUp menu generated by ASP


> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
> : > rsApps1.Open "appraiser", db,adOpenForwardOnly, adLockOptimistic,
> : > adCmdTable
> :
> :     I'm sure you've already gotten a million replies, but try:
> :
> : rsApps1.Open "SELECT * FROM appraiser ORDER BY some_field", db, _
> :     adOpenForwardOnly, , adCmdTable
> :
>
> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
>
> If you want to follow Charles' suggestion, change adCmdTable to adCmdText
> otherwise you'll get a ADODB 800a0bb9 error. :-)
>
> Also, I'd seriously suggest allocating your SQL statement to a variable, and
> passing that in:
>
> strSQL = "SELECT * FROM Appraiser ORDER BY some_field"
>
> objRS.Open strSQL, objConn, adOpenForwardOnly, adLockReadOnly, adCmdText
>
> Cheers
> Ken
>
>
>

  Return to Index