I need help bad. I have an ASP page that is used by a program in our office to upload clients information to an access database. I'm trying to convert this whole process ti MYSQL but the program does not recognize PHP files to upload data and their is no way to change that. I have contacted the vendor and they said they only support access and not mysql.
If you click on the link it will download a zip file of the page i need help with. What i am trying to do is leave the asp format as is so that the data can upload to a mysql database instead of a access DB. I know there is a way to connect ASP to mysql, but he methods i have tried have been unsuccessful.
I have created 2 asp pages called testa.asp and testb.asp
testa.asp has a link to go to next page testb.asp
testb.asp has a form that ask you for a reference number and post it to the same page testb.asp
If the reference number is not blank, it will just write out what the reference number is.
Now my problem....
If you go to testa.asp and click on the link to go to testb.asp you will see the form. At this point, if you click the back button, it till take you back to testa.asp ALL FINE SO FAR.
If you go to testb.asp again and see the form, enter a number say 33 and click on search. This will now show you the number you have just entered. NOW - click on the BACK BUTTON, it will just show you exactly the same page ! WHY does it not go back to the FORM in order to refill in a different number. Code:
I'm using formmail.asp which is an emailing utility. Basically, the user fills out a request page, clicks "Submit" and the page posts to formmail.asp which emails the user information.
I'm running IIS5 on a Win2k server box and recently ran the Windows Updates (the last time I do that). Anyway, that emailing form doesn't work now on any of the sites I host. Any ideas?
If an ASP page works locally on your system but doesn't work remotely on the web hosts server and your only alteration to the page before uploading is your connection string to make it point in the right direction on their server then surely the fault has to be the path to the servers database doesn't it?
Or is there another possibility why the page would show up an error page.
I re-installed MySQL 4.1 since 5.0 wouldn't work together with MyODBC 3.51.. So now I'm back to square one..
Conn.Execute("SELECT * FROM pictures WHERE pid NOT IN (SELECT pic FROM votes WHERE uid = '" & strUserId & "')")
Gave me syntax error..I also changed SELECT pic to SELECT pid, since thats the right fieldname.. I'm thinking that it might not be possible yet to make that kind of sub-call.. Is there a way to do it in some form of function?!? Basicly,what I want is that you'll always see a picture u never voted for before...
I'm trying to get an asp page talking to MySQL, which i have working locally using the myodbc 3.51 driver installed, but its not working when i upload the page to the web server. (im using Dreamweaver).
I have installed the myodbc 3.51 driver on my local machine, and am able to connect to the mysql db from a .asp page with DreamWeaver OK.
The connection file needs to change obviously ....
i use a IIS 5.1 with win XP with the newest updates etc. its possible to start aspx and html files but not asp files what could it be ? what can i check ?
Can a ASP work like a CGI.(Email Scripts) ? Can a ASP script for email will work, if a Script is on 1 server and form(html.form) is on another server and a thank you page is on 3rd server. Like if u don't know about a CGI there are many websites who give you permission to use their script by editing little bit in yours form and place them on yours server website, there are number of site.
And 1 more thing I want to ask is if some one use a windows server he have a form html on that server, can he run asp script which is on Linux server to get form result on his desired email id.
I am trying to construct a sub procedure that concects to db , executes a stored procedure and returns a recordset. Connection to db and executing the stored procedure works fine.
The problem is that when I call the sub in the asp page to be executed the recordset is refused to be returned from the sub and the recordset itself does not appear to be constructed. or in another words the error displayed is: 'object required' --> refering to my recordset --> 'rs'
I do not know why, can any one tell me the reason, I tried much but with no result. NOTE: For testing puropses I looped through the recordset isnide the sub itself and it worked fine Code:
Is there somebody who can explain to me how I can use a Global.asa to store Functions and Variables in it? I understand that there are 4 events that can be used in a global.asa : Application_OnStart, Application_OnEnd, Session_OnStart, Session_OnEnd
But still i don't get how i can CALL functions of variables. Because with those 4 things they start all in the beginning or in the end of a session or application.
For example i use an encrypt function in different pages, can i just put it in de global.asa and call it when i need it?
I have an asp page. In this there is a form when submit it have to chech if the fields are not emtpy.When it not empty it wil insert into a database an a mail.If a field is empty it send it anyway, it doens't do the validation. Here is a part of my code:Code:
<% if request("action") = "Verzenden" then datum = request("dtmmeldinghelp") if datum <>"" then 'I have tried also: if len(datum) <0 then response.Write("<html>" & "<body>" & "Fout" & "</body>" & "</html>") else ' here come my sql insert to code and the code for email ' this works fine %>
I am trying to add a button to a menu which it's action is conditioned by a session variable. The button shows up fine but I get no action from the button being clicked . The variable does have a valid value. If anyone can help me out with this it would be greatly appreciated. The code follows:
<SCRIPT LANGUAGE="VBScript" FOR="Button1" EVENT="onClick"> If Session("RVQuoteAuthority") = "Y" then Response.Redirect(Quote.asp) else MsgBox "No Authority" End If </SCRIPT>
Talking about the cdonts objects.. i want to send the email in windows xp.. i downloaded cdonts.dll and registered it.. but still i am not able to send the mail.. is it so that i need to set the settings in the Virtual SMTP server in IIS ?
I have not been working with ASP for too long at this time and am not real familiar with a lot of things about ASP. I have searched for articles on the following question but not come up with any definite answers. Code:
I am trying to get ASP to work with IIS and i keep getting page cannot be displayed when i try to open asp pages? Do i have some settings wrong somewhere?
I am using CDONTS to send mail to the user from my ASP application. However, the code doenst works all the time. I am able to get mails but nothing happnes most of the time. The code works maybe once in 20 tries. What could be the reason?
I have the following reference to an image in my web page. The name of the image is simply one Chinese character followed by .jpg. <a HREF="transfer/rad0/﨨.jpg" TARGET="_blank">﨨.jpg</a>
The Chinese character is HTML encoded. I'm specifically setting UTF8 encoding w/codepage 65001 in each web page. When I right click this URL and attempt to download the image to disk, I get an error saying the web server can't locate the URL. In the error message, the Chinese character is displayed as ? (question mark). It works if the URL has only ASCII characters in it.
What do I need to do to be able to download images via URLs that contain Chinese (Unicode) characters?
I am having a prob with getting for example, ASP Free Forums > Programming > etc, to display properly. I can get it to work sort of but need to be able to read in a value and be able to change it before its displayed.
It works on the first page but when going to other pages it doesn't. Also when going back to the original page, topic.asp where it works, from view topic the formatting disapears which is a mystery to me. Here is the code that gets it to work on the topic.asp page:section = Trim(Request("Section")) Code:
I am having ASP with the following code to access the file with windows scripting host. The page run on local server IIS 5.1 on Win XP Pro SP2. The IE never show me any error with this, but will keep access the page for very long. This code is running fine on other system. Code:
Pretty simple task ... page1.asp calls page2.asp and I want page2.asp to show the HTTP_REFERER (which I expect to be page1.asp).
It's blank when I try from my local machine and from other machines. HTTP_HOST, URL and various other server variables work fine so there is a work around, but I'd like to know why HTTP_REFERER doesn't seem to work
This is could be a noob question, but I don't know where to look for answer. I wanted to create form with a button that checks a boolean value and computes depend on the value. At the end of the click, it should revert the boolean value. ie, if it's true, reverts to false. or the reverse....works like a switch
Some how, it works on the first click. process1 got processed and boolean changed to false. But it doesn't work on the second click..the handler was never get called again. What's the problem?.