ASP SQL Query Error With Data Types
I am trying to use a query to filter SQL Server 2000 records by a date
value.
Here is relevant columns in my database table (tblContent):
title [nvarchar]
starting [smalldatetime]
.... and here is my query:
Query = "SELECT title FROM tblContent WHERE starting = '" & date & "'"
I've done exactly this query on numberous occassions in the past with no
problems at all but this time I get the following error:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E07)
[Microsoft][ODBC SQL Server Driver][SQL Server]The conversion of char data
type to smalldatetime data type resulted in an out-of-range smalldatetime
value.
What on earth is going on? I'm not using a char data type anywhere! I am
doing all the initial development locally and I have just installed XP
Service Pack 2. I realise it's unlikely, but that's the only thing I can
possibly attribute it to. Or am I just missing something obvious?
View Replies
ADVERTISEMENT
does the data type varchar allow numbers and characters, or just one, also if this does not allow both numbers and characters what data type can i use to do this.
View Replies
View Related
Why am I only able to create 60 currency type fields in Access 2002 (Build 10.4302.6735) SP3?
If I try to create more than 60 Currency type fields, I will get an error that says, "Too Many Fields Defined. Errors were encountered during the save operation. Data types were not changed."
What if I need more currency type fields - like about 32 more? Do I need to create two separate related tables?
View Replies
View Related
i have a problem with the data types im using right now... because i set my data type to text ang number of characters allowd is 50, what happens is everytime i entered a data that is less than 50 characters and if i displayed it the remianing blank spaces that hasnt been cosumed is displayed.
anyone here got an idea how i can control this? is this a data type problem? i cant set my data type lesser.
View Replies
View Related
I have a form with 3 submit buttons that uses Javascript to determine which of the three buttons were pressed, appends the appropriate querystring to the end of the action value of the form before submitting it. eg
if add was clicked then the action would be; process.asp?query=add
Inside process.asp I have a switch statement that should check the value of the querystring and execute the appropriate SQL query. Here is the code:
View Replies
View Related
My asp/sql server application gets an error, but only when you use the
Excel export option:
<% Response.ContentType="application/vnd.ms-excel" %> (very popular w/
users)
I think somebody entered a string of characters that Excel does not
like:
So I believe (but not sure) some character(s) in a Ntext sql server
field "desc_text" is confusing the Excel file and causing it to error
(and crashes Excel)
So far, I have attempted three fixes with no success
1) Tried to convert the data type in the SQL query:
CAST(sr.desc_text AS VARCHAR(255))
2) Tried to convert the data type in the vbscript:
<% desc_text1 = Cstr(rs.fields.item("desc_text").value)%>
3) Tried append an apostrophe to the beginning of the field so that
Excel would not read it as a formula. (this might have worked, but
Excel does not treat an apostrophe the same from an export as it does
if you typed it in directly)
<%response.write "'"%> <% response.write desc_text1%>
Soliciting all ideas!
Also, if you have any ideas on how to isolate and identify the
specific record and character(s) that is causing the error, that would
be great. I have it narrowed down to a record set of 600 records, and
the error occurs if I include beyond the 130th character position. The
problem does not occur if I use CAST(sr.desc_text AS VARCHAR(129))
View Replies
View Related
I'm trying to pass a piece of data i get from a query using a different form's passed values. This is how I get the data into the new form and how I try to pass it to the next asp page query.
<td valign=TOP width="168"><form action="HouseDetail.asp" method="post" name="MLS" id="MLS"><input name="MLS" type="hidden" value='<%=oRs("ML_Number")%>'><input name="Submit2" type="submit" value="Get Details"/></form></td>
The value='<%=oRS(ML_Number")%>' generates a real value like '2403943' - and the field I'm trying to use this value in the qry is expecting a number. But even passing the number without the single ' at both ends generates the same error message. Code:
View Replies
View Related
Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable query.
/changeprofile.asp, line 44
Code:
View Replies
View Related
I am working on a project using an access db. Here is the problem.
Error
Code:
Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
[Microsoft][ODBC Microsoft Access Driver] Syntax error (missing
operator) in query expression 'unit=6400s'
Unit is what it is suppose to be, I don't understand why I am getting this error? Here's the code for this part.
Code:
sql="SELECT * FROM " & tableStr & " WHERE Model=" & unitStr
tableStr and unitStr are variables. Table and unit are passed into the page and are assigned to the two variables through a request.querystring().
View Replies
View Related
I need to select the data where the data ID is equal to the variable supplied in the submitted form. Below is the line of code I used for the radio select and the code to do the SQL search on it. I get the following error using this code:
Error Type:
Microsoft JET Database Engine (0x80040E10)
No value given for one or more required parameters.
/MyWeb/CheckIn.asp, line 93
The items are listed by ID 1-X.
<input type=""radio"" name=""CheckIn"" value=x.value>Check In<br>
Dim junk
junk=request.form("CheckIn")
'If Session("UserType") = "User" Or Session("UserType") = "Admin" Then
Set Conn = Server.CreateObject("ADODB.Connection")
Conn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("db1.mdb")
Set rs=Server.CreateObject("ADODB.recordset")
'in below, WHERE id = Request.Form("CheckIn")
SQL = "SELECT * FROM CompsIn WHERE ID = junk"
rs.OPEN SQL, Conn, 3, 3
rs.OPEN SQL, Conn, 3, 3 = Line 93
View Replies
View Related
i try to get data form access with asp. The select contains 2 Subselects. If i set this SQl statement in Access it works. But if i set this in ASP it doesn't. Why??? There is no error. It's completly the same statement.
View Replies
View Related
I have 2 tables Table_A and Table_B are linked together by TaID
Table_A
TaID - autonumber
Name
Address
Table_B
TbID - autonumber
TaID
Comments
here is my asp page
-------------------------
<%@ Language="VBScript" %>
<!-- #include file="connectionstring.asp" -->
<%
'declare variables
DIM ......
'Assign Variables
.......
Set Conn = Server.CreateObject("ADODB.Connection")
'database connection
Conn.provider = provider
Conn.ConnectionString = dbasepath
Conn.Open
'Sql statement to insert the data
sql = "insert into Table_A ( Name, Address) values (...*data from form*...)
' execute it
Conn.Execute(sql)
Response.Write "Data successfully inserted!"
Conn.Close
Set Conn = Nothing
--------------------------------------------
my question is I also need to insert the data to Table_B, but before that, I want to retrieve the Table_A.TaID first.
so if i do "select TaID from Table_A" and execute the sql how do I assign just the LAST record of TaID and assign to temp variable?
Do I allow to do that? if so, where should I put in the code above?
View Replies
View Related
im trying to display a name from a table, by matching up where an assigned_to id = emp_id in another table. Code:
View Replies
View Related
I have this page with photo thumbnails that are clickable. Each photo has corresponding info saved on a database. When the thumbnail is click, im trying to show the data in an asp page called info.asp.
sample:
Photo #1 when clicked goes to: info.asp?no=1
Photo #2 when clicked goes to: info.asp?no=2
so on so forth..
the database fields are:
no
picname
date
details
I only know how to display ALL info from a database.
But i cant figure out how to display SPECIFIC info triggered by a query string. Example. Photo #1 is clicked. I only want the data that corresponds to Photo 1 to be displayed. How can i do this?
View Replies
View Related
I came across the following question at a website but unfortunately the answer wasn't accompanying it:
What are the special sub-types in VBScript?
What's the answer to the above question?
View Replies
View Related
I am writing a basic tournament submit site for a poker tournamen
group I am in. The situation is we want to use code to calculate wha
we owe other members at the end of the week. The way I figured to d
this is read from the database and store tournament numbers in an arra
then run a query for each tournament and cycle through the tournamen
data assigning the information where needed. I can not find if you ca
or how you can use a Typedef in ASP. Pretty much I want to create
type then make an array of that type. ie: Code:
View Replies
View Related
the cursor types and lock types while opening the recordset.
View Replies
View Related
I'm running PWS on a Windows ME machine to do some WAP development. I need to set up some mime types so that PWS can deal with .wml .wbmp and .wmls WAP files.
I'm told this can be done by either via the Folder Options -> File Types from a Windows Explorer or by editing the registry. I've tried both of these but to no avail.
View Replies
View Related
query="select * from mytable where id="&xx
id is a numerical field..
if a user choose xx char or a string my query gives an error in asp...
i tried
if err.number <>0 then response.redirect "xx.asp"
but problem is still continueing
View Replies
View Related
This is my SQL Query, but I get the error message:
Item cannot be found in the collection corresponding to the requested name or ordinal.
/spmanagerdownload/downloadadmin.asp, line 444
Code:
View Replies
View Related
Assume I have three types of users.
Type I can only Read Posts.
Type II can Read and Edit. And
Type III can Read, Edit and Delete Posts.
Now to manage this, do I need to make three different users in my DB or should I just use ASP to determine that what permissions should every user have. For example, Type I users will not have the edit and delete button on thier screens and Type II users won't have delete button on their screens and Type three would have all three buttons.
Even if I make different users in my DB (assuming it's necessary for security), so how would I determine that what connection string should I connect a specific user with since we have to give the user name and password on the ADODB connection string?
View Replies
View Related
I pass a table name into my program dynamically. I could display the data by looping through the object.Fields for both the field name and the field data using object.GetRows.
What I have not figured out is if there is a way to figure out from the Fields what type of field (ie. Numeric, Text) it is.
Certainly I could check the actual data once it is read, but is there a way to figure out the field type without doing that? Perhaps an object property of a recordset that I am not familiar with?
View Replies
View Related
I'm currently using a document upload script and saving the filename to a database field as such: Code:
RS("Title") = Form("SourceFile").FileName
What I'm trying to do is evaluate that files type (ie. doc, xls, txt...) and fill in another database field with just the document type or a variable representing it. Is there a way to just strip off the last three letters of the form input and save that seperately?
View Replies
View Related
I have a selection of MP3's on my website, (non-copyrighted of course), I have an asp page that list the directory of MP3's which then provides a link to another ASP page to force download the file.
<%
Response.AddHeader "content-disposition","attachment; filename=" & Request.QueryString("fname") & ""
%>
Up until the weekend just gone, this worked fine, but now it only downloads a 0 byte file.
Obviously my code hasn't changed, so has anyone any other ideas whats gone wrong or another way the force download of a known mime type can be acheived.
View Replies
View Related
I am trying to run an SQL SELECT query, however, I am experiencing some problems with it.
It is coming up with the error; " Microsoft VBScript compilation error '800a0401'
Expected end of statement "
It is pointing to line 46 which is highlight in bold within my code below; is the error coming up because of the way I have formatted the query?
strSQL = "SELECT * FROM tbl_lunch WHERE (((tbl_lunch.Type)="general")) ORDER BY tbl_lunch.Type;"
Thanks for any help you may be able to give me on this
View Replies
View Related
Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable query.
/SHOP/add_emp_result.asp, line 41
how can i slove this problem?
View Replies
View Related
<%
sqlQuery = "INSERT INTO contacts (firstname, lastname, email, department) VALUES (" & contact_first & ", " & contact_last & ", " & contact_email & ", " & contact_department & ")"
connect.Execute sqlQuery
%>
The error I'm getting is
Microsoft VBScript runtime error '800a01a8'
Object required: ''
/ebusiness0405asp/greg/asp/project/adminContactAdded.asp, line 57
Line 57: connect.Execute sqlQuery
Ideas?
View Replies
View Related
I need help on this error that occured on one of the pages. fuunny thing that its happen in localhost and not in the web server. below is the code and the highlight of where error occured.The error mentioned in the page is :
Microsoft JET Database Engine (0x80004005)
Operation must use an updateable query.
/shop/confirmation21.asp, line 245 . can anyone kind enuff to let me know whats it about?
Code:
View Replies
View Related
1) I have the following html code on the server:
<HTML>
....
.....
<BODY>
<A HREF = http://MyServer/MyDoc.doc> Click here to see the document</A>
When I click on the link How Internet Explorer understand that it's a Word
Document and It's necessary open it with Microsoft Word ? Is The extension
to give the necessary information to Internet Explorer ?
Where does IE look for the application to use to open the file on the server
? On the local registry ?
I have tried to rename Mydoc.doc in MyDoc.pdf and I have called
http://MyServer/MyDoc.pdf and the browser has opened Acrobat Reader but the
binary format is for Microsoft Word.
Does the Browser User an Http_Header sended automatically ? (for example
HTTP_FILE_NAME....IF IT EXISTS)
2)Now I have the following link:
http://MyServer/ReturnMyDoc.asp
It returns the binary data of MyDoc.doc file. Now I want to say to the
browser that the file is called MyDoc.doc (I don't want to use Content Type
= ms-application/msword) : is there a header to say this to Internet
Explorer ?
View Replies
View Related
I'm getting an error on my ASP page:
Microsoft VBScript runtime error '800a000d'
Type mismatch: 'StoreFileIntoField'
I assume - 99.5% - the error is generated because of worng value types,
I attemp to pass from my ASP/VBScript page to the VB/DLL function.
My relevant ASP/VBScript Code:
View Replies
View Related
I'm getting an error on my ASP page:
Microsoft VBScript runtime error '800a000d'
Type mismatch: 'StoreFileIntoField'
I assume - 99.5% - the error is generated because of worng value types,
I attemp to pass from my ASP/VBScript page to the VB/DLL function.
My relevant ASP/VBScript Code is:
View Replies
View Related
Please look over this code and tell me why I keep getting this 'Number of query values and destination fields are not the same.' error.
Set rowcreation=connectionToDatabase.Execute("INSERT INTO hotlines(user_ip,date_time_opened) VALUES('" & user_ip & "," & date_time_opened & "')")
View Replies
View Related
i'm trying to make a form that will pull details from a record that is found with (asset Number) but comes up with this error: 2342 "A RunSQL action requires an argument consisting of an SQL Statement"
Dim SQL As String
SQL = "SELECT *"
SQL = SQL + " FROM Computer"
SQL = SQL + " WHERE (((Computer.Asset)=" & TxtAsset.Value & "));"
DoCmd.RunSQL SQL
View Replies
View Related