Re: Update an SQL database

Meat wrote:
Hello Bob,

The vbscrit isn't run by an asp page,
Hmm, I've just taken another look at your code and I'm not sure now what
made me think it was. Sorry

I run it manually on a server
to see if my connection and querie to the SQL database is working
well. That's why I put those WScript.Echo. I watch it live and I
click OK when needed.

The problem I got is with this line :

Insert here:
Wscript.Echo Recordset contains '" & objRecordSet.Fields("Server") & "'"
Wscript.Echo Variable contains '" & strServerName & "'"

**********************************************************
If objRecordSet.Fields("Server") = strServerName Then
**********************************************************

It seems that this line isn't working, because I do not see the
WScript.Echo lines after, even if I know that this condition is true.

Do I need to convert both variables into text or any other kind of
data to be able to compare them?

I will better be able to answer after you have done the above.

--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.


.

Relevant Pages

  • RE: asp pages error
    ... our intranet connects to several access databases we dont get an asp ... I tried to add a new site to iis, ... > down and type the full content of the error message to the Newsgroup. ... > SP1 on your SBS 2K3 server? ...
    (microsoft.public.windows.server.sbs)
  • Re: ASP Error HTTP-500 "The Requested Resource is in Use" SBS2003
    ... Microsoft CSS Online Newsgroup Support ... I can not browse asp pages. ... >> whether there are any error messages about this issue, ... >> Microsoft CSS Online Newsgroup Support ...
    (microsoft.public.windows.server.sbs)
  • Re: Microsoft VBScript runtime error 800a01c9
    ... this is the wrong newsgroup for this. ... I would post your question to the appropriate (ASP) ... > Function InitQueryMap() ... > If I delete the global.asa file then basic asp pages work. ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Session Timer
    ... dim strSQL, timein, timeout, timespent, user ... > Nothing that can be done via ASP server-side code. ... > client-side code but even that will not be ... Post your question to a client-side newsgroup, ...
    (microsoft.public.inetserver.asp.db)
  • Re: Unknown error when open Access db
    ... This is the ASP.Net newsgroup. ... ASP.Net is a different technology than ASP. ... Microsoft MVP ... > work on Windows Server 2003 without errors. ...
    (microsoft.public.dotnet.framework.aspnet)
Loading