I have written a code in ASP. While i'm running it on my Local IIS server i'm able to store data in MS SQLServer2000 database. But when try to run the same on the web serve i'm facing the following the error..
Microsoft OLE DB Provider for SQL Server error '80040e21'
Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done.
Error Type:
Microsoft Cursor Engine (0x80040E21)
Multiple-step operation generated errors. Check each status value.
this is my code:
I have come up against a very strange error, well one I havnt got before - and was wondering is there a way around this. In my mysql db i have a price field which is set as "decimal(10,2)" but when I try read from it through my asp page I get this error at the line where i do my recordset query:
Microsoft Cursor Engine (0x80040E21)
Multiple-step operation generated errors. Check each status value.
If I change the field type to "Integer(10)" its fine, it just doesnt like the decimal for some reason . And the thing thats really throwing me off is when I write the sql string doing the query out to the page and copy it into my mysql browser and run it, it comes back fine with all the data and no error.
Mainly I am asking if someone can look at a small portion of code to see if there are any obvious problems for use with mysql??perhaps with the way dates are inserted?? Code:
View Replies View RelatedIs there any good one website which has step by step lectures on ASP shopping cart development.
View Replies View RelatedWhen simultaneous requests to open an Access Database occur, the Jet Database engine returns an error stating: Cannot Open file, already in use.
I know this occurs because I'm using a file-based Access database, and it's locked while data access is taking place. However, at this time, its the only platform available on the site.
My question is, can I somehow use an On Error GoTo Blah statement to catch the error, clear it, and then attempt the ADODB.Connection.Open statement again?
I’m trying to build an application that will flow like this “when the data from my form1 is submitted an auto increment is generated id will generated...I want to be able to used the generated id in other form or page in my application.. this is because the id would be use as foreign key in other table in the database” …is there anybody can guide me on these issue.. I manage to develop it only until the submission of the first form after that I didn’t know how to call the generated id.. For your information I’m using mysql as database.
View Replies View RelatedCan anyone provide me with, or point me in the direction of somewhere where I can get the code to get the server to create and send an email.
Basically, when an order is completed on my site, I need to create and send an email notification both to the client and also to ourselves.
Is there anything else I need to be aware of when dealing with this? Any help would be greatly appreciated.
Im trying to send plain text emails to a japanese mobile phone.they use 3G in japan. However,one make of mobile phone can't read messages when the message is generated from two strings concatenated together.yes,i dont belive it either
e.g.
message = "Hi"
message = message & " Bye"
cannot be read on one type of mobile phone (giving invalid content error).
I've also tried message = message + " Bye" but that gives the same problem.This email can be read on all otehr types of phones. A single string can be read, but as soon as the string is ended and then started again,it breaks.
going from Users to Organization (links)
or vise versa and totally at random.The error message appears in a pop up window:
"Internet Explorer cannot open the Internet site "file://C:aaProject
x.x.x.x 80.hta".
Operation aborted. OK"
After clicking OK the system will continue to work.
This problem is not consistent and is seeing on part of clients PC.
I found that most of these computers are using proxy server for Internet
connection.
Does anyone have some good advice for the following situation?
If a condition is true, an insert is restricted ( aborted ) otherwise
the insert is allowed. I have been killing myself on this for a week
with no success. I just need some advise at this point. Currently I
am running a stored proc that returns yes or no based on the variables
that a user is inputting. If the sp result is yes ( a record already
exists ) the insert isnt allowed and the user is forced to update the
existing record.
I'm using Shadow's upload script. whenever i try to upload a file larger than a few hundred kilobytes, i get this error: "operation not allowed; /_uploader.asp, line 56" at the top of _uploader.asp, i have changed the maximum file size to 50 mb. this is line 56 on uploader.asp:
View Replies View RelatedPlease help me out. I am looking to filter records to a specific day. Here is my error:
ADODB.Field error '80020009'
Either BOF or EOF is True, or the current record has been deleted. Requested operation requires a current record./calmenu.asp, line 0
<code>
<%
objRS.Filter = "eventdate = 1"
If IsNull(eventcaption) Then
eventcaption = ""
Else
Response.Write(objRS("eventcaption"))
objRS.Movenext
objRS.Filter = adFilterNone
End If
%>
</code>
I don't know the exact operators, but it's something like:
a?b:c
Which translates to:
If a = TRUE then
return b
else
return c
end If
I need this for an ASP script.
I used to have a piece of code that would generate a random string of
8,16,24 or 32 characters in length.
I got it from this group, does any one have this piece of code?
It will be used for a double opt-in email newsletter.
I want to send customers and automatecly generated email once they submit a form/place order. I've been searching the net for a whille but I haven't been able to find any usefull information.
View Replies View Related<%
for Counter = 1 to Sections
%>
<tr>
<td><input name="<%=Counter%>_Title" type="text" value="Item Number <%=Counter%>" size="40"></td>
</tr>
<%
next
%>
As you can see, the name for the text field is being generated as (in this instance) 1_Title
the form submits to another page.
How do I retreive the new value of that form?
<%=1_Title%> returns an error.
I have an insert query that creates a customer record, this record is given a ReferenceNo that is autoincremented within Access.
What I want to know is how can I retrieve this value after I have applied this update. Using MySQL I know there was a way to retrieve autogenereated keys, but is there something similar that I can do via the ADO stuff and access?
have a number of text box rows generated dynamically with the same name. This gets posted to the same page as a comma delimted string.
The Problem: If a user enters a comma the string gets disjointed.
Need to parse(remove commas)the dynamic text box values generated on client side.
I have in the past run some ASPs that generated Excel reports via the following line:
Response.ContentType = "application/vnd.ms-excel"
Response.AddHeader "Content-Disposition", "attachment; filename=rpt_s2dpoc_Access_dump.xls"
I have a critical issue where I need to from an ASP gereate and excell spreadsheet but with three tabs. I will need different sections of the asp to write to those three tabs.
Code:
i need to build a booking system which relies on a calender. basically i have a db of clinics thar offer allotted times for appointments on certain dates. eg: a clinic may offer five 20 minutes slots 2 days a week.
so i need to get the data out of the db and display that in a calender form which the user can then select the time/date convenient to them. my question is (apart from how do i build this!?!?!?!) does anyone know a good calender that would fit my purpose? Code:
I have an asp page that collects data on referrals. The user inputs the
information and selects the rep to receive the referral. My data is being
saved to a backend database (SQL) and the user is receiving a confirmation
page after hitting the Submit button. Now, what I need is a way to have an
email sent to the rep that is selected in the drop down list on the asp form.
I have a SQL table containing the reps and corresponding email addresses.
Is it even possible to achieve what I am trying to do? I am trying to avoid
sending a blanket email to a single address and having someone filter them
from there.
I know you can use the XMLHTTP object to retrieve Html, but how can you get html created by an asp page? Is there a way.
View Replies View RelatedHow could I create a random filename for a single-use download? So, if a user was to download a file from a site it would send them a unique filename that could only be used once. That link would not be available after the download completed.
View Replies View RelatedI am relatively new to this generation of variables in ASP. I am unable to proceed from here. Can somebody advise?
Challenge :
I get number of participants in an exam, from a sql statement and stored into a variable called headcount.
After that, I am using the following to initialize randomly generated variables. For example if there are 4 students in the class, I intend to get student1, student2, student3 and student4, all of them initialized to 0.
For j=1 To CLng(headcount)
Eval Execute("student" & j & "=" & 0)
Next
Now we are trying to find out question wise defaults in the test. I have a for loop that does traverse through all the questions in the test. As I go question by question, if there is any failure I would like to increment the errorcounter of that participant.
Which means .....
I am not the ASP programmer on this project so I am simply asking for possiblities.
We are using ASP to generate html documents with data drawn from a database. We need to email some of these pages to our users.
We do not want to create separate email-able versions of all of these pages. It would be ideal to create an html email or attach and html document to an email, using the html code the asp code generates on the existing page.
Can this be done? My programmers tell me that the second option (write the generated code to a file, attach it to an email, send it, delete the file) would need to use FSO and the this object opens security holes.
Can anyone point me in the right direction for tutorials etc on dynamically generated pdfs from pages created from a database.
View Replies View RelatedI have to make a page with an inline frame, in this frame will come a dynamic generated PDF.
The PDF will have to be stored on the server to load in the preview frame but after the user had loaded the pdf in his browser I want it removed.
I thougt maybe I could use a General variable defined in global.asa that counts from 1 to 100 or something and every time a pdf is generated the number = number + 1 so I can create a pdf with the name ' filename & number & ".pdf" ' so that there would be constantly 100 pdf's on the server but not more and there is no danger of mixing up the preview which users get to see because it takes a while before their number is used again / their pdf is overwritten ...
I have a client who is requesting information in a batch type form in their CMS (easy enough).And they've asked that these reports would print one per page (hmm). From my experience I don't think this is possible but thought I'd ask on the forums here.Anyone know about this?
View Replies View RelatedMy Asp database generated pages' content links all open a new window containing the same page by default; this is strange since the default behavior for anchor links is to open in the same window; I can and have corrected this with target="_self" but I have additional anchor links that call JavaScript to submit a form and these aren't stopped from opening the new window by the "_self" value.
Interestingly, once the new window is open with the original page within, the links all work as expected in that window(!?!); is there a window or DOM value I need to instantiate so the generated windows will "recognize"themselves?
I wrote an asp script to generate an email only to find there is no mail server on the server running my scripts.
View Replies View RelatedI am exporting data from ASP page to an excel sheet using the following
code.
Response.AddHeader "Content-Disposition", "attachment;filename=ExcelView.xls"
Response.ContentType="application/vnd.ms-excel"
I have two questions.
1. How the excel file gets created on the server before it is sent to the
client.
2. Is there any prerequisite for exporting the data to excel? I mean do we
need to install any software like MS office on to the server?
I've got a page that users of my website are sent to when they log in, and one part of it shows their friends (think myspace). The page works fine if the user has one friend, but it seems that if they have more than one then i get the "Operation not allowed" error.
I won't post the whole page because there's about 750 lines of it, but here's the code that gets the friends images from a mysql db and then shrinks them (if necessary) and puts each image into a table (for a tidy layout):
NOTE: "sql" is in case there is more than one users image to get, i've checked the query when there is more than one user image to get and it looks fine... Code: