ASP :: ASP SQL Query Error With Data Types

DATA TYPES
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.

Data Types
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.

Currency Data Types
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?

Querystring Data Types
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:

Data Types And Export To Excel From ASP Page
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))

Trying To Pass Form Data Gets Me: Syntax Error (missing Operator) In Query Expression
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:

ERROR (0x80004005) UPDATING ERROR Operation Must Use An Updateable Query.
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:

SQL Query On Form Data
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

SELECT Data Form A Query
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.

How To Retrieve The Data From Last Record Of The Query?
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" %>



<%
'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?

Sql Query Not Returning Correct Data
im trying to display a name from a table, by matching up where an assigned_to id = emp_id in another table. Code:

Retrieving Data From Database - Query String?
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?

Sub-Types
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?

Cursor Types
the cursor types and lock types while opening the recordset.

PWS And MIME Types
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.

Query Error
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

SQL Query Error
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:

Types Of Users On My Forums
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?

Database Field Types
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?

Sorting Document Types
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?

Downloading Known Mime Types
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.

Error With SQL SELECT Query
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

Updateable Query Error
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?

Error On Update Query
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:

How Browsers (IE) Understand File Types.
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 ?

Passing Correct Value Types From ASP/VBScript To VB/DLL
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:

Weird Error On Search Query
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

Error: Operation Must Use An Updateable Query
Does anybody know what this error is about?

Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable
query.

/app/admin/admin.asp, line 201

Table Does Not Exist Error In AD Query?
this runs perfectly as a .vbs but I'd like to convert it to an ASP... any
ideas? Code:

Select Query Database Error
I have created a query and everytime I try to run it I get this error:

Microsoft JET Database Engine error '80004005'
Record is deleted.
/vsadmin/inc/incsearch.asp, line 162

This is the query: Code:

Converting String Types In Stored Procedure
I have the following stored procedure:

CREATE PROCEDURE [dbo].[GET_CategoryCurrentNewsList]
@Category VARCHAR
AS

BEGIN

SELECT dbo.News_Joined.NewsTitle, dbo.News_Joined.NewsID
FROM dbo.News_Joined
WHERE (dbo.News_Joined.StartDate <= GETDATE()) AND (dbo.News_Joined.EndDate >= GETDATE()) AND (dbo.News_Joined.CategoryID IN (@Category))

END
GO

dbo.news_Joined.CategoryID is an INT, and @Category is a string such as (1000, 1010, 1020). However, no results are returned. I figured I had to do something to do some string conversions from INT to VARCHAR or something, but I can't use CSTR. I do not know how many numbers will be passed to @Category, so making seperate variables isn't an option.

Any ideas???

Error-checking And Query-results After Execute
After commands like:

tmpDBconn.Execute("DELETE * FROM mytable WHERE rc_id = 10" )
How do I check for errors?
Is there a way to check the results?

OR:

Set rsCatCount = tmpDBconn.Execute("SELECT COUNT(*) FROM cat WHERE key_id = 10 AND cat_id = 6")

How do I get the count? Do I use rsCatCount(0)?

QUERY: 'On Error Resume Next' Scope Rules
This has been puzzling me for very long time and no where has
talked about the scope of a 'On Error Resume Next' statement.

When we program ASP(.NET) pages then we usually like to let
ASP(.NET) stop at errors and report back to us. However there
are parts of our scripts that we know an error will be thrown
and we encapsulate that area inbetween:

On Error Resume Next
Err.Clear
'Try block
If Err.Number Then
'Catch block
End If
On Error GoTo 0

This is similar to the infamous try {} catch(e) {} blocks in
Java/C++, etc.

If we forget the last line 'On Error GoTo 0' then our ASP(.NET)
scripts runs over all errors thrown and we find it hard to
find bugs. So the big question is, does 'On Error Resume Next'
go out of scope when it's written inside a block
(eg. Function)?

Function Function1()
On Error Resume Next
'Our code
End Function

When the Function1 call returns, does the outside calling scope
automatically stays as it was (On Error GoTo 0)?

Page 2 - Syntax Error In Query Expression
to search based on the beginning characters the sql should be

sql="SELECT * FROM Employee Where Emp_Id Like '" & strId & "%'"

Error (0x80004005) Operation Must Use An Updateable Query.
I m getting the following error when executing the below given code:

====
Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable query.
=====

Code:

Syntax Error (missing Operator) In Query Expression
1) I'm getting this error: Syntax error (missing operator) in query
expression on the below statement. Can I get some advice.

2) I searched ASPFAQ and came up blank. Where can find the "rules" for when
and how to use single quotes and double quotes in ASP? Code:

Syntax Error (missing Operator) In Query Expression
I'm getting this error:

Error Type:
Microsoft JET Database Engine (0x80040E14)
Syntax error (missing operator) in query expression ''I'm not really sure what all that stuff means. Do you have the divider pages with the tabs to stick in and organize things? If so i'll take 10 of those too. Thanks.''.
/employee_forms/testing/databaseclerical.asp, line 60

when running this code: .....

ASP/Mysql Empty Text Field Query Error
I'm getting an error when I'm retreaving from a "text field" in the database and it has no data in it. I'm using MYSQL version 3.23.58-nt. I have the same script running a different system and I don't get this error. It justs output nothing and continues with the loop.

This has to be an ASP problem when retrieving data from the database. I've change the Field for Message to "varchar(252)" vice "text" in the database and stoped giving me error. But I still need to use the type "text" in the database since my "Message" will be longer then 252 caracter. Code:

Syntax Error (missing Operator) In Query Expression?
I'm getting this error:

Error Type:
Microsoft JET Database Engine (0x80040E14)
Syntax error (missing operator) in query expression ''I'm not really sure what all that stuff means. Do you have the divider pages with the tabs to stick in and organize things? If so i'll take 10 of those too. Thanks.''.
/employee_forms/testing/databaseclerical.asp, line 60

when running this code: ....

Syntax Error (missing Operator) In Query Expression
Any ideas why im getting this error from these lines of code?

" WHERE [Personnel].p_id = [specialists].[p_id] " & _
" AND*[specialists].spu_id = " & Cint(Request.form("spec"))

Syntax Error (missing Operator) Query Expression
valuA = (request.form("toadd"))
If valuA = "" then
SQL = "UPDATE CourseReg SET attended='Active' WHERE ID
IN("&request.form("toadd")&")"
Set RS = MyConn.Execute(SQL)

End If
MyConn.Close
Set RS = Nothing
Set MyConn = Nothing
the error
syntax error (missing operator) query expression ID IN ()

Erro Message - Syntax Error (comma) In Query Expression...
I am trying to execute the following SQL Statement:

SqlApp1 = "INSERT INTO LeagueStore (Team, Played, Wins, Loses, Draws, For, Against, Points) SELECT (Team, Played, Wins, Loses, Draws, For, Against, Points) from HomeWins WHERE postponed=''"

But i am getting the following error message:

Syntax error (comma) in query expression '(Team, Played, Wins, Loses, Draws, For, Against, Points)'.

And i dont know why. All of the fields are numerical apart from TEAM is that helps.

All i want to do is Insert data from one table into another but i cant use SELECT * because one table has one extra field to the other and when i tried to amend the SQL to look like this:

SqlApp1 = "INSERT INTO LeagueStore (Team, Played, Wins, Loses, Draws, For, Against, Points) SELECT * from HomeWins WHERE postponed=''"

i get this error:

Number of query values and destination fields are not the same

Syntax Error (missing Operator) In Query Expression '''undefined'''.
I am trying to insert values into a database using an sql statement that i read from a table that contains all my different sql commands. The sql statement is stored in the following way in the table: Code:

(0x80040E14) Syntax Error (missing Operator) In Query Expression Single Quotes
I am recieving the Microsoft JET Database Engine (0x80040E14) Syntax error (missing operator) in query expression when updating data that contains single quote marks, for example: Code:

Data Submission Error...
I have a hidden input type that contains an item's id. When I try to use the data the sent variable contains all of the item numbers in the column delimited by a comma which I do not add.

The SQL statement I use ends up looking like this: UPDATE CompsIn SET ProjectTask ="asdf" WHERE PropertyNumber='sCSU345, sCSU802, sCSU810'

All of the items on the page are in one form, would making each have its own form fix this problem?

Error While Inserting Data
I'm currently tring to insert data into an access db using asp. I have a form which is found in a popup window and which contains the fields Name and Comment. When I click on the Submit button,I call a javascript function in order to redirect the user to the page that will save the name and comment.

However,I am having an error like this:Field 'VoicesComment.Name' cannot be a zero-length string. The problem is that the value from the previous page in the popup window is not retrieved. I have tried retrieving the name entered and the page does not return anything.
The code for the page that is supposed to save data is as follows: Code:

Data Type Error
i am getting this error Code:

Microsoft OLE DB Provider for SQL Server error '80040e07'

Syntax error converting the varchar value 'Canvas' to a column of data type int.

/store/administrator/special.asp, line 98

what i am doing is selecting an item from the drop down and i have textbox i want to display the items price from the table here is the code:

Data Type Error
I am trying to do a comparison between two values and am getting the following error:

Microsoft JET Database Engine error '80040e07'
Data type mismatch in criteria expression.

The code that is creating the error is as follows:

sb = Request.Form("storyboardscreen")

if Not Lcase(Request.Form("AllStoryBoard")) = "all" then
whereClause = whereClause + "theStoryboard = " + sb
end if

I am using the statement to build the where clause of my query. The sb value is retrieved from a pull down menu and "theStoryboard" column is the db is of data type "text". The values stored in the field are 12 digit numbers. I have tried doing a cstr to sb but that doesnt work, any tips on what I am doing wrong? I am using asp with an access db.