For all my ASP references I use the following sites http://www.w3schools.com/asp/default.asp http://www.w3schools.com/vbscript/vbscript_ref_functions.asp
To answer your question , use the Cstr (convert to string) function to convert variants to strings. Jared Clinton NEC Australia -----Original Message----- From: Julia Green [mailto:[EMAIL PROTECTED]] Sent: Wednesday, 6 March 2002 10:02 AM To: CF-Talk Subject: ASP Question because my manager wouldn't acceot ColdFusion I hope this is acceptable to ask as people ask Javascript questions sometimes. But how do you cast an autonumber in an Access table to a text string in ASP. Does anyone know the answer to this... The originating html form has the text name ID... <%@ Language=VBScript%> <!--#INCLUDE FILE="ADOvbs.inc"--> <% Dim oRS, sqltext, varID, varID2 Set oRS=Server.CreateObject("ADODB.Recordset") varID=Request.Form("ID") oRS.Fields("ID").value=CStr(varID) sqltext="Select * from EMAIL WHERE ID='" & varID & "';" oRS.open sqltext, "DSN=emaildev", adOpenKeyset, adLockOptimistic 'If oRS.EOF or varID2="" Then 'Response.Redirect("updateoops.asp") 'End If %> Need help thanks... I wrote the whole thing successfully in ColdFusion, but my manager didn't want to buy it. Julia Green Julia Computer Consulting Email: [EMAIL PROTECTED] --- Ian Lurie <[EMAIL PROTECTED]> wrote: > Robert, you da man. I sit corrected - we were using SQL Server 2000 > for > client storage. I switched to registry storage as an experiment, and > it s > ped > right up. > > Did you just create a new client var store, or actually reinstall SQL > Server...? > > -----Original Message----- > From: Robert Everland [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, March 05, 2002 3:28 PM > To: CF-Talk > Subject: RE: Slow CF response times? > > > I had this problem when I used client management with an external > databas > e. > I reinstalled the database and it made the response time what I > expected. > > Robert Everland III > Dixon Ticonderoga > Web Developer Extraordinaire > > -----Original Message----- > From: Ian Lurie [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, March 05, 2002 6:20 PM > To: CF-Talk > Subject: Slow CF response times? > > > Hi all, > > I'm getting slow response times from CFM templates on a production > server. > Many of these templates execute in 150 ms or less on our dev server, > and > asp and .htm templates on the production server are showing up just > fine. > > If you want to experiment, go to: > > http://winpisinger.iamaw.org - that's a .html page. > > Then go to: > > http://winpisinger.iamaw.org/home.cfm > > See the difference? What's weird is that home.cfm doesn't do ANY CF > processing. It's just an experiment to try to figure out why the > server's > so > slow? > > The server is a dual processor Pentium III with 1024 meg of RAM, so > traff > ic > isn't the issue, either... > > Any ideas? > > Thanks, > > Ian > > Portent Interactive > Using Process, Design and Content to create great web sites since > 1995 > Consulting, design, development, measurement > http://www.portentinteractive.com > > > ______________________________________________________________________ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists