Hello, I haven't moved to NET yet. Still using good old ASP and ADO plain
vanilla. Is there a newsgroup that I can ask a question on? All I see are
the ..NET versions.
Actuall I have VS Net loaded but everytime I go in the Dev Env I get
overwhelmed. :) Can't get the Debugger to start(F5) . I guess what I am
saying is that I'd be happy to try .NET if I could get over the culture
shock of the IDE. Can this IDE run my old ASP code? Any suggestions. For
kick, I'll show you the code block I'm using and maybe someone can tell me
if this is easily converted to .NET.
Thanks in advance.
Rich
This code usually works the first time I run it, but if I hit refresh it
fails with:
"Unspecified error
/cosmetic/ask_dup.asp, line 12"
which is the connection.open statement.
Makes me think it's an ODBC driver issue since I am closing the recordset
and connection objects.
<% @LANGUAGE="VBSCRIPT"%>
<HTML>
<HEAD>
</HEAD>
<BODY >
<SELECT NAME="category">
<OPTION>Select a category... </OPTION>
<%
Set conn = Server.CreateObject("ADODB.Connection")
conn.open "cosmetic"
sql = "SELECT * FROM tblCategory"
Set rs = conn.execute(sql,inNumRecs, 1)
If (rs.EOF and rs.BOF) then
Response.End
else
rs.MoveFirst
do while not rs.EOF
%>
<OPTION VALUE="<%=rs("id")%>"> <%=rs("category")%> </OPTION>
<%
rs.MoveNext
Loop
end if
rs.close
conn.close
Set RS = nothing
Set conn = nothing
%>
</SELECT>
</BODY>
</HTML> 1 1306
microsoft.public.inetserver.asp.general
HTH,
Kevin Spencer
Microsoft FrontPage MVP
Internet Developer http://www.takempis.com
Big things are made up of
lots of Little things.
"RP" <ex*******@yahoo.com> wrote in message
news:5F********************@newsread2.prod.itd.ear thlink.net... Hello, I haven't moved to NET yet. Still using good old ASP and ADO plain vanilla. Is there a newsgroup that I can ask a question on? All I see are the ..NET versions.
Actuall I have VS Net loaded but everytime I go in the Dev Env I get overwhelmed. :) Can't get the Debugger to start(F5) . I guess what I am saying is that I'd be happy to try .NET if I could get over the culture shock of the IDE. Can this IDE run my old ASP code? Any suggestions. For kick, I'll show you the code block I'm using and maybe someone can tell me if this is easily converted to .NET.
Thanks in advance. Rich
This code usually works the first time I run it, but if I hit refresh it fails with: "Unspecified error /cosmetic/ask_dup.asp, line 12"
which is the connection.open statement.
Makes me think it's an ODBC driver issue since I am closing the recordset and connection objects.
<% @LANGUAGE="VBSCRIPT"%> <HTML> <HEAD> </HEAD> <BODY >
<SELECT NAME="category"> <OPTION>Select a category... </OPTION> <% Set conn = Server.CreateObject("ADODB.Connection") conn.open "cosmetic" sql = "SELECT * FROM tblCategory" Set rs = conn.execute(sql,inNumRecs, 1)
If (rs.EOF and rs.BOF) then Response.End else rs.MoveFirst do while not rs.EOF %> <OPTION VALUE="<%=rs("id")%>"> <%=rs("category")%> </OPTION> <% rs.MoveNext Loop end if rs.close conn.close Set RS = nothing Set conn = nothing %> </SELECT>
</BODY> </HTML> This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: Shannon Jacobs |
last post by:
Trying to solve this with a regex approach rather than the programmatic
approach of counting up and down the levels. I have a fairly complicated
HTML page that I want to simplify. I've been able to...
|
by: Natt Serrasalmus |
last post by:
After years of operating without any coding standards whatsoever, the
company that I recently started working for has decided that it might be a
good idea to have some. I'm involved in this...
|
by: Andy M |
last post by:
ALERT
There is a person by the name of Mike Cox who's trying
to turn this mailing list into a Big-8 newsgroup. Many
of you know that this and most of the other postresql
mailing lists are...
|
by: TC |
last post by:
I'd like to open a discussion about the state of the industry. For the
past year, I've been unable to find competent Access developers
available for hire. I'm worried about that.
I think there's...
|
by: Nicholas Reville |
last post by:
Hi, I hope this is an OK spot for this question:
I'm a co-founder of the Participatory Culture Foundation
(pculture.org), we're a non-profit that develops Democracy Player and
some related...
|
by: Dave |
last post by:
I'm never quite sure whether to use "this." or not when referring to fields
or properties in the same class. It obviously works just fine without it
but sometimes I wonder if using this....
|
by: John Salerno |
last post by:
Ok, I've been browsing through the MySQLdb docs, and I *think* I know
the kind of code I need to write (connect, cursor, manipulate data,
commmit, etc. -- although I probably need to get more...
|
by: kamarajbca |
last post by:
dear sir,
Now I am doing the task that the index page contains the US
states Map.When i am pressing on the particular state that state map
will be open.I create the link to states using with...
|
by: DolphinDB |
last post by:
Tired of spending countless mintues downsampling your data? Look no further!
In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
|
by: ryjfgjl |
last post by:
ExcelToDatabase: batch import excel into database automatically...
|
by: isladogs |
last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM).
In this month's session, we are pleased to welcome back...
|
by: Vimpel783 |
last post by:
Hello!
Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
|
by: jfyes |
last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
|
by: ArrayDB |
last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
|
by: Shællîpôpï 09 |
last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
|
by: af34tf |
last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome former...
| |