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
>
>
>
______________________________________________________________________
Dedicated Windows 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=coldfusiona
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
