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?
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.
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?
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.
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:
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)
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))
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.
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:
Microsoft OLE DB Provider for ODBC Drivers (0x80004005) [Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable query. /changeprofile.asp, line 44
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().
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
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
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.
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?
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:
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="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
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?
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?
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?
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.
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.
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
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
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?
<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 ?
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