Actually I found out the answer on my own.
sqltext="Select * from EMAIL WHERE ID=CStr('" & varID & "');"
Thanks anyway.
Julie
--- Jared Clinton <[EMAIL PROTECTED]> wrote:
> 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
> > >
> > >
> > >
> >
> >
> >
>
>
>
______________________________________________________________________
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
