I am establishing a connection with a database and by using a query generating output(extracting from the database). On every line of output, there is a checkbox. I want the user to select which ever output he/she wants(via the check box) and press enter at the bottom. This is working fine.
On the next page I want the page to only show the selected output(selecxted by the checkbox on the first page).
My questions.......
1) How do I count dynamic output coming out of the database?
2) After the user selects.......how do I know which line he/she selected(in order to reproduce on the second page)?
3) How do I put those values on a session variable(the database output)?
What I am trying to do is......basically create a shopping cart, which lists the item, then calculates the price on the item........and so on and so forth. I am badly stuck on the first step.
I've created a mail database for a friend, but she also wanted it to create .docs for printing for those without e-mail.
Her database looks something like this......
name|address|email|mail_type
mail_type being "email" or "post"
Sending emails to all with mail_type="email" is simple enough, and creating the doc output for the letters/envelopes is easy as well.
What I'd like is suggestions on actually outputting the docs. I need it to display 3 outputs, the HTML of the next page after form submission, the doc output for the letters and another doc output for the envelopes. Code:
I am new to programming in ASP so please forgive me if this seems trivial. I am editing a page someone else created. The page loads a list from a database, based on the selections (by clicking on the an item in the list it gets highlighted) the user has the option of pressing a button to reload the page with just what they have chosen all same page but calls others for queries and such. This page contains a <form> then has the button to reload with the selected events then </form>.
I am trying to add the function to output the selected events to Excel, which I have been able to do by changing the page. The problem is we would like two buttons, one to output to a web page, the other to a Excel. Is possible to have two submit buttons in a form, one for web output and the other for Excel?
My problem with the database connection of MS access.when we transfered the site to new server which contain windows2003 server and frontpage2003 too.it's hapened that following error when I browse the site.
Database Results Error The database connection named 'database1' is undefined.
This problem can occur if: * the connection has been removed from the web * the file 'global.asa' is missing or contains errors * the root folder does not have Scripting permissions enabled * the web is not marked as an Application Root
I am new to asp pages and vbscripting and am having a problem trying to get a form in a html document to be submitted back to a asp page, then into a microsoft access database.But not sure what I am doing incorrectly. Every time I fix one error I seem to get another error.
This is the latest error, and I believe the problem exsists in the ASP page? Something to do with the connection, that it is not seeing the Nano.mdb database. It is set up correcly under the System DSN in the ODBC data source. Any ideas?
Microsoft OLE DB Provider for ODBC Drivers- Error '80004005'
[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
/WPF Project/NanoGroup.asp, line 39
Also would the connection string be in the include file or in the ASP file. If it is in the asp file, then do I need to attach the include file? Code:
I am designing a questionaire for my partner for her uni degree, I have done the form, created the database and written the add.asp script so the form data can be added to the database.
When you enter the data and send it, it works and even goes to the thanks.asp page. HOWEVER, when i check the database, the script has created a new autonumber for the new submission but has not filled in any of the data from the form.
I have included the add script below, the database field names match up to. Code:
The problem is that I can run the ASP files in the wwwroot folder when I use http://localhost from my browser or RUN (and that's for the default.asp). But the asp files do not work when I call them from a hyperlink in an HTML file.
After I moved the site to new server the mailing method stoped working , the cdo pull the email from sql database on the same server .. although it says sent to # recipients. I send a webpage (newsletter) exisit on the server "I use full url" also the registration page gives when registration the error: CDO.Message.1 error '80040218'
Unknown Error
/extra/news/reg3.asp, line 251
line 251 is objSendMail.CreateMHTMLBody "http://www.example.com/newsletter.html" I saw description of the error it sayes that I have to use full url ...but I am using it ... any Idea ...
I have a sever 2003 machine of which I am trying to host a webisite on. The webpages I uploaded has lots of .asp files that could not be open. I'd contact the website disgner and complains about it and an he blaims it on my server not supporting asp technology. My question today, is there a way to test what the problem really is?
The server gets to the end since I place a response.write in to test.
If I cut and past this into VB declare the variables as objects and lineout as string and remove the "Server." from the line when setting fs, then it works fine in VB.
The problem is that I can run the ASP files in the wwwroot folder when I use http://localhost from my browser or RUN (and that's for the default.asp). But the asp files do not work when I call them from a hyperlink in an HTML file.If I do that, all I see are the contents of the asp file.
Just set up Dedicated Server Hosting with GoDaddy. I put a very simple ASP page in the home web directory and try to load it and get a very generic error. A simple HTML file works fine. Obviously it's a permissions issue or maybe some service is not running.
New to IIS, Why will IIS 5.0 not server up my ASP web pages? I cannot even get to the help because it is an ASP Page. I get an error in IE that states "HTTP 500 Internal server error". I have looked in the configuration and cannot find anything related to ASP. What can I do to serve up ASP web pages?
Im finishing up a content management system for a client. It works fine except the way they have the pages set its nessessary for someone to open each page made and change it to the new directory.
the script copys a folder from lets say
http://fake/templets
To
http://fake/user so now we end up with something like http://fake/user/smith
On the pages in smith is there a way to make the look at their url and strip off all but the /smith part?
Or maby someone could tell me what im trying to do is called and ill be able to do a better search online.
Here are the scripts. interest is 0, but, it will not execute then clause. Why?
interest = round(rs("CURR_WORKING_INTEREST")) response.write interest if sizeworkint < 3 OR interest<>0 then CURR_WORKING_INTEREST2 = left(rs("CURR_WORKING_INTEREST"),2) + ".000000" end if ..
I just noticed my upload function isn't working since I have move the folders and files to different directory.
Now I get this error:
Error Type: Persits.Upload.1 (0x800A003D) Wrong Content-Type. Make sure you have included the attribute ENCTYPE="multipart/form-data" in your form. /foldername/UploadScript.asp, line 54
line 54 is: Upload.Save "z: ewfolder"
I have given modify, read & write permission for IUSR_MachineName account on NewFolder and given Read & Write permissions in IIS.
I also included ENCTYPE="multipart/form-data" attribute in my upload form.
I'm using IIS 5 on a win xp machine for all my testing, before I upload to our live server. I've installed the SMTP service and it's running with no errors.
Dose anyone know anything about the above set-up not supporting "CDONTS.NewMail" for sending email using ASP..?
I get the following error message: "Server object, ASP 0177 (0x800401F3) Invalid class string".
I have taken some SQL from MS Access and got it working. I have since updated the SQL in Access but cannot get the additional part working in ASP. The working SQL I have in asp is:-
strQuery = strQuery & " HAVING ((OrderQuantity-Sum(QtyShipped)>=0) AND (OrderLines.SelectAll=-1) AND (PCBForecast.HeldMarker='Scheduled'))"
I need to add the following but keep getting errors saying my SQL is incorrect.
This is the additional part which should also be on this line:-
AND ((PCBForecast.ShipETA) Between Now() And #12/30/3000#))"
or another variant I require
AND ((PCBForecast.ShipETA)=#12/31/3000#))"
What is the correct way to write both of these, as I cannot get either to work in asp, yet they work in Access.
whati have is a table that alternates colour each row so making it easier to look at the info. I also have it to check so that if the stock level is below min change from standard to red.
I also want it to check now so that if it has been ordered instead of being red green instead. i thought this would do it but i dont know how to check database to see if the check box is ticked. Tried Yes/No True/False and even both "yes" or "true" and so on. Code:
I have the following ad rotator that dosent show any errors or pictures. In my root directory I have a folder called "ads" and in the folder there are a few gif's.
In my html folder I have the file called "banner-inc.asp" which contains the following code:
I am generating my menu dynamically as a dhtml menu. however the third level 'MenuSubCat'. I cannot get it to display properly and to loop all the third level sub menus to correct second leve menu. Code:
I'm using ASP to access an MS Access database. One issue that I'm constantly having problems with is Date/Time records.
What I'd like to know is how does one work with date variables in ASP?
My current problem is this...
I have two variables, Mnth and Yr, which each hold an integer. Mnth holds between 1 and 12 ( a month ), and Yr holds the desired year (2005 for example).
With only these two variables how can I generate a full date to use in an SQL query, such as:
SELECT * From Table WHERE DateAdded>??<date value here>??
test = request.servervariables("HTTP_REFERER") response.write test
It just gives me blank page and does not give me the URL. I tried request.servervariables("REMOTE_ADDR") it gives me the IP address but HTTP_REFERER is not working. What could be the reason.
I am running win2k3, iis6, access db's, for a web app. The problem is that asp stops working randomly. No errors in IIS log, no errors in even viewer. It just stops serving asp. Restarting IIS clears up the problem. This occured under win2k but maybe once a month. Not that I switched to win2k3, it happens 4-5 times a day. Any ideas? What would be the difference?
The page code can be viewed at http://www.onthescene.co.uk/loginpagecode.htm the error messages on both firefox and IE6 don't tell me anything other than its an 'internal server error'. Ive spoke to my web host and they say they can't help as they dont give programming support.
I am connecting MS Access Database from my ASP Page and trying all possible options. The DSN-less way works fine, even the System DSN and File DSN works fine, but the problem arises when I try to use the USER DSN. It just doesn't work. The error message I got is "Data Source Name not found and no default driver specified" It seems its looking for the system DSN only when I use the following code :
SET Conn = Server.Createobject("ADODB.Connection") Conn.open "DSN=myUserDSN"
I have created the user DSN called "myUserDSN" successfully under the USER DSN tab of ODBC drivers. So why it doesn't work?
