If ID is an autonumber it is a numeric-type column, putting quotes around
it
in any language will cause you problems.
Instead of
> sqltext="Select * from EMAIL WHERE ID='" & varID & "';"
why dont you try
sqltext="Select * from EMAIL WHERE ID=" & varID & ";"
Hope this helps,
Jared Clinton
NEC Australia
-----Original Message-----
From: Julia Green [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, 6 March 2002 10:30 AM
To: CF-Talk
Subject: RE: ASP Question because my manager wouldn't acceot ColdFusion
I know it is the CStr, but I am doing something wrong database wise,
could you look at the code I sent, and tell me what I am doing wrong??
Julia Green
Julia Computer Consulting
--- Jared Clinton <[EMAIL PROTECTED]> wrote:
> 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
