Thread 25 of 25 | Thread Starter | | |  donna lee | ASP MailHow 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 29 replies. Last post: |  donnalee | {Too Long!} |
|
 5194 Hits | |
Thread 24 of 25 | Thread Starter | | |  aka51 | view table infoI 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 recordset23 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. |
|
 4673 Hits | |
Thread 23 of 25 | Thread Starter | | |  Yesid.B | ODBC Join tablesI 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.
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
|
|
 1637 Hits | |
Thread 22 of 25 | Thread Starter | | |  cmccullough | Coding ASP Classic on LinuxHello 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.
|
 11854 Hits | |
Thread 21 of 25 | Thread Starter | | |  Me | Help with some code{Too Long!} 6 replies. Last post: |  Me | I know, I've fixed it |
|
 7733 Hits | |
Thread 20 of 25 | Thread Starter | | |  charbrad | Need help with subtotals{Too Long!} 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 |
|
 14871 Hits | |
Thread 19 of 25 | Thread Starter | | |  ParaDelphi | Exit a While LoopI've been looking all over, how do you exit a while loop? I tried exit and that didn't work.
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. |
|
 11512 Hits | |
Thread 18 of 25 | Thread Starter | | |  aka51 | Viewing info selected from a tableI 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") , 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. |
|
 3931 Hits | |
Thread 17 of 25 | Thread Starter | | |  aka51 | Error evaluating CHECK constraint{Too Long!} 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 |
|
 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 3 replies. Last post: |  Johnc | {Too Long!} |
|
 3840 Hits | |
Thread 15 of 25 | Thread Starter | | |  Mike Prestwood | Description of ASP.NET (was ASP+){Too Long!} 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 |
|
 3584 Hits | |
Thread 14 of 25 | Thread Starter | | |  Mido | View records in table ???Hi all ....I'm your neighborhood next door  from delphi forum  ... 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 ?? 2 replies. Last post: |  wpantoja | {Too Long!} |
|
 3091 Hits | |
Thread 13 of 25 | Thread Starter | | |  CathyHendricks | Data Entry Forms{Too Long!} |
 3936 Hits | |
Thread 12 of 25 | Thread Starter | | |  Bryan Valencia | ASP Classic Suddenly fails{Too Long!} 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.
|
|
 11423 Hits | |
Thread 11 of 25 | Thread Starter | | |  John Anderson | Remote Access DatabaseI 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. 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".  |
|
 3919 Hits | |
Thread 10 of 25 | Thread Starter | | |  khatib_b | Diplaying javascript error message from DB{Too Long!} |
 5606 Hits | |
Thread 9 of 25 | Thread Starter | | |  Vikas Athavale | Connect Sql Server on WebPlease inform me the sytax for connectring SQL server on web, , Thanksing u in advace, Vikas AThavale 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" |
|
 4032 Hits | |
Thread 8 of 25 | Thread Starter | | |  pihl | aspmailHi 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? 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 |
|
 3118 Hits | |
Thread 7 of 25 | Thread Starter | | |  rohitpabby | Running EXE from a HTML LinkHi 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. 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. |
|
 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? 1 Reply: |  mprestwood | Alter pay.inc. In the future, we will gradually include various merchants. |
|
 5522 Hits | |
Thread 5 of 25 | Thread Starter | | |  ASPGuy | IIS On Windows XPI'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.
|
 4521 Hits | |
Thread 4 of 25 | Thread Starter | | |  soji_ng | Asp on windows XPI 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 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.
|
|
 3289 Hits | |
Thread 3 of 25 | Thread Starter | | |  aka51 | ASP queryI 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.
1 Reply: |  Paul.S | How did you solve this? Was it with the in keyword? |
|
 3801 Hits | |
Thread 2 of 25 | Thread Starter | | |  aka51 | ASP queryI 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. 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... |
|
 2354 Hits | |
Thread 1 of 25 | Thread Starter | | |  deleted_member | Data Environment ProblemI'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. |
 5172 Hits | | |
|