IT SOLUTIONS
Your full service technology partner! 
-Collapse +Expand
ASP Classic
Search ASP Classic Group:

Advanced
-Collapse +Expand ASP Classic Store

Prestwood eMagazine

February Edition
Subscribe now! It's Free!
Enter your email:

   ► MB LobbyASP Classic Coding Board   Print This    All Groups  

ASP Classic Coding Most Active Threads

  


25 Threads:

,

Thread 25 of 25
Thread Starter  

donna lee
ASP Mail
How can an html format be integrated into the following code:, , strMsgHeader = "Form information follows" & vbCrLf, for each qryItem in Request.QueryString, strMsgInfo = strMsgInfo & qryItem & " - " & request.querystring(qryItem) & vbCrLf, next, strMsgFooter = vbCrLf & "End of form information", Mailer.BodyText = strMsgHeader & strMsgInfo & strMsgFooter
23 years ago
29 replies. Last post:

donnalee
{Too Long!}
23 years ago
Nothing New Since Your Last Visit
5194
Hits

Thread 24 of 25
Thread Starter  

aka51
view table info
I am using ASP and this is the code I am using, ,
, <%, dim rsmail, sql, , Sql = "SELECT "& request.form("SELECT") &" FROM "& request.form("DATABASE") &" where "& request.form("WHERE_FIELD") &" = '"& strwhere &"';", , , set rsmail = Server.CreateObject("ADODB.Recordset"), , rsmail.Open sql, db, if not rsmail.EOF then, do while not rsmail.EOF, %>, , <% Response.Write rsmail("Action") %>, , , <% Response.Write rsmail("can") %>, , , <% Response.Write rsmail("emp_name") %> , , , <%, rsmail.MoveNext, loop, end if, %> However I will recieve anerror if I try to write the info to the screen as each select statement will select different things from the database so if one of the recordset (rsmail) was not selected it will cause an error., Is there a way to write it without specificing which recordset
Posted to MB Topic: ASP Classic - Handling Data
22 years ago
23 replies. Last post:

rbonas
that is where it was then when you suggested I look into the connection string being the problem i moved it out and it worked. All my other files are using an include file, I am just a little apprehensive to mess with it again.
22 years ago
Nothing New Since Your Last Visit
4673
Hits

Thread 23 of 25
Thread Starter  

Yesid.B
ODBC Join tables
I am attempting to join two tables through an 'INDEX' field like so: SELECT w.LOCATION, w.BOLIN, w.DATEIN, w.LOT, w.QTY, w.UNITMEAS, w.CUSTCODE, w.WEIGHT, w.PRODUCTCODE, , w."INDEX", w.QUAR FROM wrhse AS w, items AS s , WHERE w.DATEOUT IS NULL AND s.poCode ='"+txtpoCode+"' AND w."INDEX" = s."INDEX" However I am not getting a result. Initially I was using the following: sql = 'SELECT * FROM subitemsTEST.DB WHERE poCode = '"+txtpoCode+"' order by index desc' to get the indexes and from there I would get the data from 'wrhse' having the indexes. But when I get more than 192 rows for some reason the system does not display the complete result set. Why can this be? How can I join two tables? Thank you in advance.
Posted to MB Topic: ASP Classic - Handling Data
7 years ago
10 replies. Last post:

amna.s
If you need a limousine for an important occasion, such as a wedding or a client visit, you need to ensure that your service provider lives up to the expectations of the occasion.  https://alternativestips.com/alternatives-of-putlocker
58 months ago
Nothing New Since Your Last Visit
1637
Hits

Thread 22 of 25
Thread Starter  

cmccullough
Coding ASP Classic on Linux
Hello all, First, I should let you know that I am not an experienced ASP coder and, honestly, don't have lots of experience with Microsoft products.  I've been using Unix for more than 20 years and Linux for about 10 years.  Most of my programming experience is with Perl and Python. I just landed a new client that needs some code work on their current online training that they offer.  It's written in ASP Classic and running on a Postgresql back-end.  I don't have experience with ASP Classic but can pick-up on the language relatively quickly (I think).  I will do the work on a Windows XP box if I have to but would prefer to do the coding one of my Linux boxes, if possible.  Does anyone know if this is even possible? Thanks for your help.
17 years ago
Nothing New Since Your Last Visit
11854
Hits

Thread 21 of 25
Thread Starter  

Me
Help with some code
{Too Long!}
Posted to MB Topic: ASP Classic Coding
22 years ago
6 replies. Last post:

Me
I know, I've fixed it
22 years ago
Nothing New Since Your Last Visit
7733
Hits

Thread 20 of 25
Thread Starter  

charbrad
Need help with subtotals
{Too Long!}
Posted to MB Topic: ASP Classic Coding
18 years ago
5 replies. Last post:

charbrad
My post is there more than once because I was getting a thread error each time I hit save reply...sorry
18 years ago
Nothing New Since Your Last Visit
14871
Hits

Thread 19 of 25
Thread Starter  

ParaDelphi
Exit a While Loop
I've been looking all over, how do you exit a while loop? I tried exit and that didn't work.
Posted to MB Topic: ASP Classic Coding
17 years ago
5 replies. Last post:

Paul.S
Thanks to both of you. Great help as usual. I did get it from Mike's post but the example is nice especially for others looking on.
17 years ago
Nothing New Since Your Last Visit
11512
Hits

Thread 18 of 25
Thread Starter  

aka51
Viewing info selected from a table
I am selecting info from an access table. the constraints for the select table are coming form another form so the information selected is never the same. Is it possible to write only the records that are selected in one command instead of writing each record individually like , , response.write rs("name"), response.write rs("age") ,
Posted to MB Topic: ASP Classic - Handling Data
22 years ago
5 replies. Last post:

rbonas
I would love to have you look at the site but it is on an intranet, so public access is not possible. , But you do have the jist of the situation. The SQL statement is being generated dynamically, so I know that I can't hradcode rsmail as it will change with every run of the SQL statement, so I need to know how to get the info that was selected from the databse to be written out.
22 years ago
Nothing New Since Your Last Visit
3931
Hits

Thread 17 of 25
Thread Starter  

aka51
Error evaluating CHECK constraint
{Too Long!}
Posted to MB Topic: ASP Classic Coding
23 years ago
4 replies. Last post:

jdschram
one other thought is that the constraint is actually on a field...like you have a field that cannot be null in the table you are trying to insert into...best bet is still to response.write your variable and work on it in access alone...that way you can be 100% sure it is not the DB that is causing the problem
23 years ago
Nothing New Since Your Last Visit
8287
Hits

Thread 16 of 25
Thread Starter  

Johnc
ftp/asp headache...
I wrote an ASP program that utilizes an FTP download feature, grabbing files that are stored in a paradox database and places them wherever the user wants on their hard drive. My question and problem is that our Users that download the files from our NT server have no problems opeing the files when download, however our users that grab files from our windows2000 server cannot open the files until the Web Server(Windows NT where i installed IIS and host the website) is reset, apparently the files get locked up, Paradox assumes the users are opening the files from its current location, but they are just grabbing a copy of the files from my website and storing the file on their hard drives...any ideas why this locks up only on the windows 2000 server...thanks
Posted to MB Topic: ASP Classic Coding
24 years ago
3 replies. Last post:

Johnc
{Too Long!}
24 years ago
Nothing New Since Your Last Visit
3840
Hits

Thread 15 of 25
Thread Starter  

Mike Prestwood
Description of ASP.NET (was ASP+)
{Too Long!}
Posted to MB Topic: ASP Classic Coding
24 years ago
2 replies. Last post:

jdschram
I just started using ASP+, and I really like it....it take's a little getting used to because you dont use recordsets (so to speak) and really dont use the response.write command much at all....So far There have been cool things I like about it, like using DataGrid to display your data, and form validators make it a snap to provide error checking on input objects.., , JS
23 years ago
Nothing New Since Your Last Visit
3584
Hits

Thread 14 of 25
Thread Starter  

Mido
View records in table ???
Hi all ....I'm your neighborhood next door Big Grin! from delphi forum Big Grin! ... this my first Q here in ASP hope to get answer., My Q is that I have an MDB file and it contains one field .... and I want to view the records in many columns and rows .... so could you please help me ??
Posted to MB Topic: ASP Classic - Handling Data
24 years ago
2 replies. Last post:

wpantoja
{Too Long!}
24 years ago
Nothing New Since Your Last Visit
3091
Hits

Thread 13 of 25
Thread Starter  

CathyHendricks
Data Entry Forms
{Too Long!}
Posted to MB Topic: ASP Classic - Handling Data
23 years ago
2 replies. Last post:

CathyHendricks
{Too Long!}
23 years ago
Nothing New Since Your Last Visit
3936
Hits

Thread 12 of 25
Thread Starter  

Bryan Valencia
ASP Classic Suddenly fails
{Too Long!}
Posted to MB Topic: ASP Classic - Handling Data
15 years ago
2 replies. Last post:

Bryan.V
Actually, after much anguish, I found that the latest MS patch had inadvertently changed my site from Low(iis) to Medium(Pooled) Setting it back did the trick. asp classic sites dont work on medium
15 years ago
Nothing New Since Your Last Visit
11423
Hits

Thread 11 of 25
Thread Starter  

John Anderson
Remote Access Database
I have read every knowledge base article Microsoft has written on the subject of connecting to a remote Access database from an Active Server Page and have done everything the articles say to do and still come up with the error:, , The Microsoft Jet database engine cannot open the file ''. It is already opened exclusively by another user, or you need permission to view its data., , I know the file is not open, so that leaves permissions as being the cause. I've given every account in the f***ing domain full control of the share and file on the file server and still no dice., , Who is making the call from the web server to the file server? Can somebody tell me that?, , My web server is Win 2k running IIS 5 and the remote Access database is on a Win 2k server that is a domain controller., , Any light anybody can shed on this would be most , appreciated.
Posted to MB Topic: ASP Classic - Handling Data
22 years ago
2 replies. Last post:

SANDMAN
It maynot hurt to run this too:, , http://www.microsoft.com/technet/treeview/default.asp?url=/technet/security/tools/locktool.asp , , Also run a complete virus check., , Think "Code Red" and alike, any of them that use "IIS"., , I though I had a clean system ... but still found afew of these that use "IIS". Eek!
21 years ago
Nothing New Since Your Last Visit
3919
Hits

Thread 10 of 25
Thread Starter  

khatib_b
Diplaying javascript error message from DB
{Too Long!}
Posted to MB Topic: ASP Classic - Handling Data
15 years ago
1 Reply:

dmichael
{Too Long!}
15 years ago
Nothing New Since Your Last Visit
5606
Hits

Thread 9 of 25
Thread Starter  

Vikas Athavale
Connect Sql Server on Web
Please inform me the sytax for connectring SQL server on web, , Thanksing u in advace, Vikas AThavale
Posted to MB Topic: ASP Classic - Handling Data
22 years ago
1 Reply:

jdschram
OLE, Set objConn= Server.CreateObject("ADODB.Connection"), objConn.Open "Provider=SQLOLEDB.1;Integrated Security=SSPI;_, PersistSecurity Info=False;Initial Catalog=_, YourDB;_Data Source=YOUR_LOCAL_SERVER_NAMEDSN, Set objConn= Server.CreateObject("ADODB.Connection"), objConn.Open "DSN=mySystemDSN;" & _ , "Uid=myUsername;" & _ , "Pwd=myPassword"
22 years ago
Nothing New Since Your Last Visit
4032
Hits

Thread 8 of 25
Thread Starter  

pihl
aspmail
Hi all., , I have a problem using ASPmail. I atemp to send some html where there is include a picture. The problem is that the picture is not there, when I open the e-mail., , Any help to get?
23 years ago
1 Reply:

jdschram
make sure it is not a relative link to the image , , , < !-- instead make it like this -->, , This should send the image ok
23 years ago
Nothing New Since Your Last Visit
3118
Hits

Thread 7 of 25
Thread Starter  

rohitpabby
Running EXE from a HTML Link
Hi All!, , I can run an EXE from a DOS prompt, passing parameters with it. Now I want to do the same thing through an HTML page by clicking a hyperling. How to do this? Please Help...., , Thanks.
Posted to MB Topic: ASP Classic Coding
24 years ago
1 Reply:

wpantoja
It is not recommended to do that because of the very large security risk. However, all you need to do is create CGI or ISAPI script which you pass parameters to and it in turn executes the EXE.
24 years ago
Nothing New Since Your Last Visit
2770
Hits

Thread 6 of 25
Thread Starter  

Badzooka
In the eStore, how do you integrate credit cards?
In the Prestwood eStore, how do you integrate credit cards?
22 years ago
1 Reply:

mprestwood
Alter pay.inc. In the future, we will gradually include various merchants.
22 years ago
Nothing New Since Your Last Visit
5522
Hits

Thread 5 of 25
Thread Starter  

ASPGuy
IIS On Windows XP
I'm used to developing on Windows 2000 and recently I finally upgraded to Windows XP Home edition. Does XP come with IIS? I do much ASP development and I like to develop all on my box and do not wish to set up a IIS server.
18 years ago
1 Reply:

mprestwood
{Too Long!}
18 years ago
Nothing New Since Your Last Visit
4521
Hits

Thread 4 of 25
Thread Starter  

soji_ng
Asp on windows XP
I develop on windows 2000 and just migrated to XP pro. I was able to enable IIS but it seems not to be able run data driven web applications. the web app does not connect to the database
17 years ago
1 Reply:

mprestwood
I can confirm that what you are trying to do can be done (I do that all the time). What are you trying to connect to? Also, can you connect to that database on your new computer from something other than ASP? Finally, show me your connect string and I'll take a look.
17 years ago
Nothing New Since Your Last Visit
3289
Hits

Thread 3 of 25
Thread Starter  

aka51
ASP query
I am submitting a query in an ASP page. , , It is a tow piece query and I am not sure the correct process to accomplish this., First I am , , , SQL ="SELECT OAID1 FROM tblOrganization where branch_labid = "& Request("branch_labid") &";", then the valuse returned from this query i would like to use it in the next query , , , SQL ="SELECT aoemail, aofirstname, aolastname FROM tblAO where OAID1 = (tring to use the value from the previous query here)", I tried to combine the select statement as below , , SQL ="SELECT aoemail, aofirstname, aolastname FROM tblAO where OAID1 = (SELECT OAID1 FROM tblOrganization where branch_labid = "& Request("branch_labid") &" ); " but I get the , [Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 1. , , Can anyone offer some help.
Posted to MB Topic: ASP Classic Coding
23 years ago
1 Reply:

Paul.S
How did you solve this? Was it with the in keyword?
17 years ago
Nothing New Since Your Last Visit
3801
Hits

Thread 2 of 25
Thread Starter  

aka51
ASP query
I am submitting a query in an ASP page. , , It is a tow piece query and I am not sure the correct process to accomplish this., First I am , , , SQL ="SELECT OAID1 FROM tblOrganization where branch_labid = "& Request("branch_labid") &";", then the valuse returned from this query i would like to use it in the next query , , , , SQL ="SELECT aoemail, aofirstname, aolastname FROM tblAO where OAID1 = (tring to use the value from the previous query here)", I tried to combine the select statement as below , , , , SQL ="SELECT aoemail, aofirstname, aolastname FROM tblAO where OAID1 = (SELECT OAID1 FROM tblOrganization where branch_labid = "& Request("branch_labid") &" ); "but I get the , [Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 1. , , Can anyone offer some help.
Posted to MB Topic: ASP Classic Coding
23 years ago
1 Reply:

jdschram
The first thing to do is instead of executing the SQL, do a response.write of your sql before you execute it, followed by response.end This will show you the sql statement you are trying to execute and then ending the program before you get the ADO error... , , The next step is to get the query to work...copy paste what is shown in the response.write and try to run it in access/query analyzser/etc...or just post your sql here...
23 years ago
Nothing New Since Your Last Visit
2354
Hits

Thread 1 of 25
Thread Starter  

deleted_member
Data Environment Problem
I've got a problem that involves using the Data Environment with an interdev, application. We've deployed an interdev application to the IIS server., When we attempt to run the asp page we get the following error, , Server object error 'ASP 0177 : 800401f3', , Server.CreateObject Failed, , /db/global.asa, line 46, , Invalid class string, , , line 46 is Set DE = Server.CreateObject("DERuntime.DERuntime"), , I wasn't able to find this class on the server, and I assume that this has, to do with the installation of IIS and the deployment of the application., I've been out to Microsoft's website and haven't found anything that really, seems to relate to my problem. Do you lhave any insights? My current, thought is that the data environment runtime is not installed or maybe not, registered correctly. If that is the case how does one get that registered, / installed. We have ado25 installed.
Posted to MB Topic: ASP Classic Coding
25 years ago
1 Reply:

bprestwo
{Too Long!}
25 years ago
Nothing New Since Your Last Visit
5172
Hits
Sales Website: www.prestwood.com Or visit our legacy sales site: 
legacy.prestwood.com


©1995-2025 Prestwood IT Solutions.   [Security & Privacy]