I am writing a VBS File Which will Take Data from an SQL Database and put it into a text file. I am getting an error on: myFile.Write NewLine (myFile is set to FSO.CreateTextFile, and NewLine is the text I am trying to write)
I have found this error is being produced When I try to "write" this text from the database:
<p><b>Moviní On Printed Throw Blanket</b></p><p>
The Problem is on this "Square" Charecter. I used the Asc() Function and got the Charecter value as 63, and Did a replace on it and it still does not work. I don't know how this charecter got in the database in the first place. I don't know if that charecter will show up correctly on this forum. But the character just looks like an empty box.
I'm building a text file from a database table using the ASP Write Method and would like to position the cursor in a specific column position before writing the fields. As I loop through and write the fields into strings of rows, I want to be able to put field1 in row1/column position1, field2 in row1/column position10,.....etc.
I've included the basic code to write a string of text. I understand the process of how to write the fields and loop, etc. If you would be kind enough to just show me in there the syntax for positioning the cursor before the write I will then apply it to my code:
It became clear to me that using a Request.Form object doesnt work after a Request.BinaryRead. I never had to deal with the BinaryRead Object Method, so this is quite new for me.
I'm using a script to upload files to my server (this script uses the Request.BinaryRead). Besides the file, users submit there name and a checkbox (if checked of course). I want to use the data submited by the user, but the Request.Form object doesnt work .how can i access the tekstfield and checkbox, if cant use the Request.Form object?The answer will be simple probably, but my searches on google didn't give me an answer.
Is there a way to determin if the email message was sent? I have a numnber of applications that use CDONTS to send mail from both ASP and ASPX pages. If the server is down mail does not get sent. I do not see a way to determine this by code. Does anyone know of a way?
I wanted to add this method to my .asp page in order to dynamically choose a page based upon some selection criteria. It's in my .asp book and in the online reference. Yet when I use this object, the following error returns in the browser:
Error Type: Microsoft VBScript runtime (0x800A01B6) Object doesn't support this property or method: 'Response.Redirect' /testwebs/choose.asp, line 22
What is missing from my IIS libraries in order to use have this method supported?
Can't get this to work. I'm creating a workaround for the absence of aspJPEG on my server. I'm using aspUpload but my server only uses aspThumb. After aspThumb optimizes the original pic the file size changes and I need to reflect that change. When using aspUpload I can reference it's built in File object references but they only refer to the "original" file. There's an easy solution when using aspJPEG but not with aspThumb so I'm trying to get the "new" picture size using a scripting object with this script but I'm getting this error.
Microsoft VBScript runtime error '800a01b6'
Object doesn't support this property or method: 'objPictureSize.Size'
/admin/media_upload_picture_process.asp, line 107 ....
We are using .net 1.1 on windows 2003 server. This is we are facing in our production server.
When we are doing the load testing we are getting the bellow error. While the load testing this error is not coming frequently. When we run 20 threads for 3 mins we are getting this error message 2 or 3 times. But this line of code is executed by all the threads. Code:
I want to open a recordset object on an .asp page. When I open the recordset I would like to use a stored procedure that expects a parameter to be passed for the stored procedure. I will then use the recordset to loop thru the recordset, update values from the recordset and then update the database by passing parmeters to another stored procedure.
I would like to use the recordset object but can it be used to pass a parameter to a stored procedure? Do I need to use a command object to open the records instead in order to pass the parameter to a stored procedure?
I have downloaded the DiscIDCalc program from CDDB. I've used it a lot because I've written my own application for my CD collections (keeping track of the track information of each CD, track duration etc). I've already got all my CDs into the application, I'm now just going through each of the disc again just to add in the DiscID information. I do it by running the DiscIDCalc program, generating the DiscID, and then then copying and pasting this DiscID into my application and then save it. if anyone has successfully generated the DiscID within an asp page? Now I have to have my browser up and this DiscIDCalc program up. Just want to know if there's a way to incorporate the two together (even if it means I'm not using the DiscIDCalc anymore.). This DiscIDCalc has a documentation for its DiscIDCalcDLL.dll but it's not something that I can CreateObject with, so I'm quite clueless... I don't want to use VB to write APIs for that
I use query string to search for records by using GET method. This method will generate querystring automatically by using the form name. Using search field together with drop down is fine but the problem is when i didn't enter any keyword or left the search field blank it won't display any result.
Unless I put "%" in the search field. How do I make the querystring change to "%" whenever the field is blank so that all records will be displayed.
i am trying top update a field in my sql database but it wont let me??? does anyone know if my syntax is correct?? I have a field called userId in the database and want to replace it with my form request. Code:
When using ActiveX Combo Boxes, can you use the GetString method to populate the control? I currently am using AddItem, however, it is taking a long time to process. I know that GetString works well to improve the performance. Here is my code while using AddItem:
Now this is a weird one. I'm having a problem with a system in development. When I post data from a form in IE 5.01 it works fine, but in IE 5.5 it refuses to post the data to the server and in IE 6 it's scatty -- works sometimes but not others. Anyone seen this before? Edit: By the way -- this is normal VBS/ASP running on IIS 5 on an NT server
I have a form that ignores my form validation code. My code works if I use the post method of <%=Request.ServerVariables("SCRIPT_NAME")%>.
But, If I post the form to another .asp page, which I prefer, the code doesn't work. Do anyone have any suggestions? Here's my code.
I have a form that ignores my form validation code. My code works if I use the post method of <%=Request.ServerVariables("SCRIPT_NAME")%>. But, If I post the form to another .asp page, which I prefer, the code doesn't work. Do anyone have any suggestions? Code:
I have a service provider that's sends sms messages from clients mobile phones to my asp page, problem is I don't know how to show the data and they are not being helpful. The process is simple as outlined below (instructions from service provider
Example: If you provide this: http://www.yourdomain.com/sms/sms.asp then we will do a post via a standard HTTP GET as follow:
http://www.yourdomain.com/sms/sms.a...ISO-8859-1&udh= How do I receive the url with the parameters in the address bar?
I have a .asp page that uses the post method and it works fine on my computer using iis. But when i put it on the web server (it has windows NT4) it wont work.
I've read that you have to do something to allow the post method on the server.
i know nothing about windows NT4 but can get access to the server. can someone please let me know what i have to do to get this to work?
Just to let you know the post method is for ssending a login and pass to another page that search a database for the record. If there is another way to do this that does not show the variables in the url please let me know. i am also willing to make it so that everything is on the same page so i dont have to pass anything.
The Folowing code is not working anymore.(500 error)
Set objRS = strSQL1.Execute strSQL1 = "SELECT * FROM BannerRotor where BannerID=" & cstr(BannerID) objRS.Open strSQL1, objConn , 2 , 3 , adCmdText If not (objRS.BOF and objRS.EOF) Then [ objRS.Fields("Exposures").Value =objRS.Fields("Exposures").Value + 1 objRS.update End If objRS.Close
The .execute Method works fine
strSQL1 = "UPDATE BannerRotor SET Exposures=Exposures+1 WHERE BannerID=" & cstr(BannerID) objConn.Execute strSQL1
i have a search page script which consists of a text field and a pulldown menu. the search function using search text works but not the pulldown menu. do I have to set separate recordset for each of the search functions, one for the search using text field and another using pulldown menu?