ASP Page To Work With Mysql
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.
View Complete Forum Thread with Replies
Related Forum Messages:
Page 2 - ASP Pages Wont Work On Iis Xp Pro
1 - Yes, Norton Internet Security 2003 2 - NTFS 3 - Radio button selected = "A directory located on this computer" Checked = "read", "log visits", "Index this resource" Execute permissions drop down = "Scripts only" Application protection drop down = "Medium (Pooled)"
View Replies !
Page Break Not Work For Excel By Asp
I have tried <p style="page-break-before: always;"></p> and <style type="text/css"> .break{page-break-before: always;} </style> But it seems no work. I really take a page break for a particular row. How can I do it?
View Replies !
ASP - Form Redirect To Same Page - BACK Button Does Not Work ???
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:
View Replies !
Formmail Email Page Won't Work After Windows 2000 Update
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?
View Replies !
Page 2 - ASP + MySQL
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...
View Replies !
Connecting .asp Page To MySQL
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 ....
View Replies !
Asp Does Not Work
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 ?
View Replies !
Can It Work Like A CGI?
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.
View Replies !
OnAfterPrint Cannot Work
cannot using onAfterPrint in IE 6.0, the page can print but cannot close. Why?? my code like as below <body : <script language="javascript" type="text/javascript"> <!-- window.print(); //--> </script> </body>
View Replies !
I Cannot Get This Inner Join To Work In Asp
<!--#Include Virtual="/bug/adovbs.inc"--> <title>Bug Status Board</title> <% Dim conn Set conn = Server.CreateObject("ADODB.Connection") conn.Open "Provider=SQLOLEDB; Data Source = (local); Initial Catalog = techsupportBT; User Id = sa; Password=" Set rs = server.CreateObject("ADODB.Recordset") sSQL="SELECT T.BugIndex, T.[Date Entered], T.DESCRIPTION," sSQL= ssql &" T.Company, T.Technician, T.Developer, T.PROGRAM, " sSQL= ssql &" T.Status, T.PRIORITY, T.[Version Fix], n.noc" sSQL= ssql &"FROM TSHIGHISSUES INNER JOIN noc ON T.BugIndex = n.bugindex " set rs=conn.Execute(ssql) and this is the error message that I get Error Type: Microsoft OLE DB Provider for SQL Server (0x80040E14) Incorrect syntax near the keyword 'INNER' I cannot find an example anywhere that helps with this situation. This works fine in SQL, but for some reason asp is being a pain.
View Replies !
Why Sub Procedure Does Not Work
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:
View Replies !
Global.asa How Does It Work?
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?
View Replies !
Cookies Doesn't Work
I created a permanent cookie with this code: Response.Cookies("chronology").Expires = #January 1, 2038# Response.Cookies("chronology").Path = "/myDir/" Response.Cookies("chronology").Secure = FALSE It seems to work, the cookie is created in the directory "c:Documents and SettingsmyLoginCookies" correctly e in my application it works. close the browser, I open again my application and everything is like at the ginning.the cookie is still there, but the couples key/value have been deleted, as the cookie was overwritten.How can I avoid this problem?
View Replies !
Work Week
I need to provide a pulldown with work weeks displayed.Is there any easy way to do this? I would like to go 6 months from the current date and show a week as Oct. 11- 15.Which is Monday to Friday.
View Replies !
Validation Does Not Work
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 %>
View Replies !
Aspfunction Does Not Work
i built this test program: <HTML> <HEAD><TITLE>Test</TITLE></HEAD> <BODY> the time is <% = Time %> </BODY> </HTML> It does not show the time! very basic probably but not for me.
View Replies !
CR Doesn't Work With SQL Server
I get the error Error Occured Reading Records: Server has not yet been opened. when I am trying to view a report using the asp pages for crystal reports. It works fine for access files. Can someone help me on it?
View Replies !
Button Won't Work
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: <input TYPE="submit" NAME="Button1" VALUE="Quote Generator"> <SCRIPT LANGUAGE="VBScript" FOR="Button1" EVENT="onClick"> If Session("RVQuoteAuthority") = "Y" then Response.Redirect(Quote.asp) else MsgBox "No Authority" End If </SCRIPT>
View Replies !
Focus Doesn't Work
I have just instered a small javascript in order to give focus to the first field when the page is opened/loaded but it doesn't work at all. All I have is: function window_onload(){ window.thisForm.ProductID.focus(); } I have exactly the same code for my other web page and that works just fine, I don't get it, I am on a different pc at the moment, could it work on one and not other? What do I need to look for?
View Replies !
IF/Then Statement Doesn't Work
I am sorry about posting such an elementary question, but I just can't get this to work: <%if (Recordset1.Fields.Item("notes").Value)="" then%> <%else%> <tr><td>Additional notes: <b><%=(Recordset1.Fields.Item("notes").Value)%></b></td> </tr> <%end if %> I just want to say if recordset "notes" is empty, don't do anything. If it is not, then write <tr><td>Additional notes: <b><%=(Recordset1.Fields.Item("notes").Value)%></b></td> </tr> However, the words "Additional notes:" keeps showing up on every page, regardless of whether "notes" is empty or not. What am I doing wrong?
View Replies !
How CDONTS Work ??
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 ?
View Replies !
Does GetObject Work With ASP?
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:
View Replies !
Session.LCID Does Not Work
The problem is, even when i set the LCID property at the beginning of my code, it always returns the date in brazilian date format. Example: <% @Language=VBSCript %> <% Session.LCID=1033 %> <% Response.write (now & "<BR>" & Session.LCID) %> This code should return: MM/DD/YYYY HH:MM AM or PM 1033 But it´s returning: DD/MM/YYYY HH:MM 1033 Do you see? The LCID is correct but it keeps showing the date in brazilian format? What the hell is happenning?
View Replies !
CDONTS Doesnt Work Always
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?
View Replies !
How To Get Unicode Characters To Work In URL?
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?
View Replies !
Separate File Does Not Work.
i have this css file. default.css Code: #navcontainer ul { margin: 0; padding: 0; list-style-type: none; } when i put both codes at 1 file, everything are ok, but when i separeted them into different files, nothing happened. what's wrong with the code?
View Replies !
If Else Statement Wont Work
i have this if endif condition but it doesn't seem to work if date = "12-06-2007" then response.write "its december 6" else response.write "its not december 6" end if and i try this also but its not working either if day = "6" and month = "December" and year = "2007" then response.write "its december 6" else response.write "its not december 6" end if
View Replies !
Getting Webpage Position To Work
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:
View Replies !
FileSystemObject Scripting Don't Work
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:
View Replies !
HTTP_REFERER Does Not Work Properly
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
View Replies !
Button Work As A Switch
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 something like protected bool myBool = true; ...... if(myBool){process 1....myBool = false;}elseprocess 2....myBool = true;} 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?.
View Replies !
CDONTS Doesnt Seem To Work
i posted earlier, and the response seemed to be there is another dll i need to use the cdonts object, i used it fine for awhile on my old setup, i upgraded to 2k3 and it errors up as if cdonts isnt an object. So is there a dll i need to have to use the cdonts object in iis 6 or do i need to rewrite my code to use cdo? (if so, please provide asp 3 example on how to send an email with recepient, sender, body and subject)
View Replies !
ASP String Function Does Not Work
I'm trying to figure out why the Left function doesn't seem to work. One of the pages fails with an error: Microsoft VBScript runtime error '800a000d' Type mismatch /status.asp, line 45 Line 45 is: response.write Left("This is A Test!", 6) Where is the Type mismatch? All my references say this should work, and give me "This i" as output. The Right function doesn't work either. But the MID function does work.
View Replies !
Obtaining Work Hours
I have a request from the boss to make a report that will require me to display how many hours something has been in a particular state. (As in status). Hard to explain. Anyway, I need to go to the table in the db, find all rows for a particular trouble ticket, find when they were put into one of our 7 statuses, when they were put into another status (this info is already in those rows), then determine how many hours they spent there in each status. So a ticket report will say that ticket 1000 spent 4 hours in customer research, 5 hrs in our company coding. 3 in our company testing, 4 in customer testing, etc. The thing is, It has to assume an 8-5 workday, and leave out any hours which don't fall in between 8 am to 5 pm, and also rule out any weekends.
View Replies !
If Statement Doesn't Work
This problem occurs only when I use NetScape browser. Here is the code: If (strFileType = "image/pjpeg") and (strFileSize < "999999") Then do A Else do B End If It couldn't verify file's extension or file size. The if statement would jump right into "do B"... Even though the file is a JPG and it is less than 90kb. I do not have this problem when I use IE browser. I think this is a hard one. Well, I want to give it a shot anyway.
View Replies !
How To Work With Byte Array In ASP?
I am getting byte array from COM to ASP page like this, This array is having DOCUMENT Image from Database. set objData = CreateObject("MemoService.FileAttachement") bRet = objData.GetAttachedDocument(strClipID) Here, bRet contains byte array. When I try to open that document using response.BinaryWrite bRet I am not able to open the file in the browser. It is writing only the file name (for ex. c: emp.doc)
View Replies !
Why FileSystem Doesnt Work Wit My IIS 5.01 On XP
I have got a problem wit da FILESYSTEM in ASP coding. Before I use window 98 installing PWS. Everything works fine.... And now, I use Window XP professional ( Laplop ), everything is updated ( Service Pack, .NET component, ASP.net stuff... All my ASP code with FileSystem which used to be properly ran cant be executed on my XP server. There is no message error on da page, but the browser icon keeps spinning and da content is blank, it means u dont see anything happens. I wanna ensure dat all da code is right, cos it work properly with PSW and other servers. I even tested with a simple code, but It still doesnt work..... Code:
View Replies !
Trim() Doesn't Work
I cannot figure out why this won't work, but I cannot get the trim() function to work for me. I tried this test code just to see if I could get anything:Code: <% String = "This is a string" response.write String & "<br>" Trimmed = Trim(String) response.write Trimmed And the results are both the same.This is a string. Can anyone think of any good reason the Trim statement wouldn't be working I cannot think of any other common ASP function that isn't working for me.
View Replies !
Script Doesn't Work 2003
I have an .asp scrip to retrieve information from a Sybase database,running it on NT server (IIS4) work fine. When I am runing the same script on server 2003 (IIS6) work fine when the rows to retrieve are less than 700, when retrieving large amount of data I got the following error message using IE "Action canceled Internet Explorer was unable to link to the Web page you requested. The page might be temporarily unavailable." and "Document contains no data" using Netscape. Retrieving less than certain amount of rows, in this case less than 700 work fine.
View Replies !
Wont Work On Server
i have made a script and it worls no the local host on my pc but does not work on the server.all of my other asp scripts on the server work any ideas y this would work on the local server and not on the internet?
View Replies !
File Upload Does Not Work
I'm using FileUPload from softartisans (not my choice, but my company's), and in our testing environment, the anyonymous web user can successfully upload and delete files to the server (iis 5.0/win2000). However, in our production environment (same software/hardware setups), the web user can only delete a file, the file upload doesn't work. I've set if Err's do a response.write after each and ever step...and no errors are written out. i can do a generic response.write("Test") at the top, middle and bottom of the script and it prints on the page. The IUSR_xxxxxxx internet guest account has modify access for the directories (identical to the testing environment).
View Replies !
Non-file Fields Don't Work
I have a form that has the user fill in a date, title, & browse for a file to upload. If I comment out the file upload & ONLY have them fill in the date & title using the default form encryption (application/x-www-form-urlencoded), everything works fine. If I comment out the date & title and change the form encryption to multipart/form-data, the file uploads fine. BUT, if I leave the encryption type as multipart/form-data and UNcomment the date & title, I get an error. They both come through as empty strings. Why is this? And is there any way around it aside from breaking the form into two pages?
View Replies !
Session Timeout Doesn't Work
I have just inherited a system which I have to maintain so if I'm missing something obvious here then go easy. The problem is my sessions won't timeout with any reliability. Sometimes they do and sometimes they don't. There doesn't appear to be any consistency to it. In my global.asa file: Code: Sub Session_OnStart session("logged_in") = "FALSE" session("whereTo") = 0 session("user_project") = "" session("client_id") = "" Session.Timeout = 20 End Sub Are sessions just unreliable by their nature or am I missing something?
View Replies !
A Work Flow System With ASP
We have got several forms in our company related to product information and documentation.This forms created by some people and go on a way for approval of other people(General Managers,Assistant General Managers etc...) But all of this is done manually at the moment.What I want to do is create an APPROVAL system which the people enter by their usernames and passwords,give approval to his/her related form and reminds the others from his/her approval.(System will do it automatically) There will be approximetely 12-15 people using this system.The security must be very important here.The pages after he/she logs to the system will remind them the work he/she will going to do at that time.All these people have different approval tasks on different forms. I hope I can explain the system to you.The problem is in how a way that I am going to do this.Will I create a page for all those people one by one?? This will be very absurd in a programming environment.I must be do it dynamically but how??
View Replies !
|
TRACKER
