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:
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:
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: Code:
I have a Function in VB Script that generates a signature. I assign the result to a variable and then need to do a hidden post to an ASP Page for further processing.
Basic functionality is I have a button upon pressing it -- It does the hidden post.
Code looks like this. Please assist with passing this stringToSign variable to the .asp page via hidden post. Code:
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?
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:
the cursor types and lock types while opening the recordset.
View Replies View RelatedI'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.
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 RelatedAssume 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?
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'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.
<%
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.
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:
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?
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 ?
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???
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))
How to display this str in a proper format accordingly to the MIME type specified in side the str? Code:
View Replies View RelatedI've always been looking for the best way to get an accurate percentage
statistics.
For example, in a election scenario:
Person A gets 33 votes
Person B gets 33 votes
Person C gets 34 votes
Person D gets 35 votes
Total votes = 33 + 33 + 34 + 35 = 135
Percent for A = 0.244.... = 0.24 = 24%
Percent for B = 0.244... = 0.24 = 24%
Percent for C = 0.251... = 0.25 = 25%
Percent for D = 0.259... = 0.26 = 26%
Then add up the percentage values: 24 + 24 + 25 + 26 = 99
(where it should be 100)
So, does anybody have a way to get around this problem? How should I
calculate the percentage for each person so that the percentage will add up
to 100 in the end?
I am trying to parse this response.write string but its coming up with a formatting error - can someone please tell me where I'm going wrong?Code:
Response.write ("<input name=""URL"" type=""text"" value=""http://www.evolvewebsitedesign.com/news-indiv.asp?news=" & rssite("News") & ""/>")
I am needing to response.write a variable within a snippet of Javascript.
My Javascript code that I need to response.write with the variable is below:-Code:
response.write ("imageArray[ImageNum++] = new imageItem(image_dir + ""variable here"");")
I can response.write the static Javascript string fine. The problem arises when I try and state a variable into where it says, 'variable here'
The variable I need to include is
Code:
rs.Fields("ImgURL")
Would someone please be able to show me the correct formatting for this Javascript string which includes the variable.
My asp syntax is very lacking, it seems the double quotes that have been
done by me are not what asp is looking for. Anyone that could correct my
faulty thinking would be thanked.
how to display correct time according to user timezone
i want to do an online meeting let say schedule meeting at 1:00pm server time, how do i display the correct time for users in their local time
I have a form where users can enter search criteria for various products.
now, if this form has 2 fields, colour and size (it wil have more but I'm
assuming the the principle for two fields will be the same for ten fields)
what would be the correct syntax for performing a query where the user
didn't enter a criteria for both fields?
the search string would be
strSQL = "SELECT * FROM products where colour = " & "'" &
request.form("searchstrcolour") & "'" & "AND size =" & "'"
request.form("searchstrsize") & "'" & " ORDER by price"
so if the user selects blue and large, thats fine
but what if the user only selected say blue and didn't bother with the size?
is there a wild card that I could use?
can someone explain to me the diffrence between the 2 below and why one works and the other one doesnt.could you also explain what each part of the correct version is doing because i dont really no.
INCORRECT
sql = "SELECT * FROM userlogon WHERE (username)=' "& (username) & "' AND (password)=' " & (password) & " ' "
CORRECT
sql = "SELECT * FROM [userlogon] WHERE [username]=' "& username & "' AND [password]=' " & password & " ' "
is it active server pages or application service provider .which is correct
View Replies View Relatedchk whether the code is correct? For the update date
SQL_query1 = "update Activity_Status set TotalTime = '" & Request.Form("time") & "', Score = '" & Request.Form("QuizScore") & "', Activity_Name = '" & Request.Form("QuizType") & "',ActivityDate = '" & "#" & Date() & "#" & "' where UserID ='" & Request.Form("username") & "' and Activity_Name='" & Request.Form("QuizType") & "'"
i need to delete some values which have dates that are less than today's from a table. The date is in another table so i joined the two tables together and gave a clause
I did this:Code:
DELETE *
FROM RMASerial, Sold
WHERE RMASerial.SoldID=Sold.SoldID
And Sold.Warranty_date<Date();
But that doesnt seem to be working.
I have a few pages that require login to access. Assuming a user clicks a
link containing a variable trying to access a password protected page. That
user is redirected to the login page. After login, he's brought to a "logged
in" page. How do I retain the original link he clicked and instead of
redirecting to a logged in page, he's redirected to the page he originally
requested?
Im trying to make a client area on my website and an not sure on how to go about editing clients details.When the client logs in they are brought to a menu where they can update there record. How can i get the appropriate record from the database so they can update there details?
View Replies View Related