I am looking for some help creating a login page. I want to have a Access DB with the username/password/forward address. I want it to forward the user to there page depending on the username. I have seen many login pages but none that will forward to a web page depending on the username.
View RepliesIf I have two different kinds of users on my website say simple posters and moderators, how do I differentiate between the two on my site while they move from page to page. I mean, I cannot append the user type ids with the web address to transfer the value from page to page since anyone wold be able to alter it. If the value is accessed from the DB every time a user requests for a page, then the program will become inefficient, wouldn't it?
View Replies View RelatedI am writing an asp file to edit records in an access2000 db. I do a query on the primary key, then if EOF and BOF (nothing found), it writes to the db. If not, it does a second test to see if any info has changed. Here's the relevant code:
View Replies View RelatedI do contract work for an organization that has some of the word code I have ever seen. I think they are using some sort of screwy CMS or something.
The code on their pages are pages stacked on pages, in other word one page loaded into a browser might have 3 <html><body></body></html> sets. Its really bad. So I started working on a page that has a form. It is included in the main page with this line of code:
Will IIS6.0 recognize a global.asa file located in a subdirectory on the webserver?
I'd like a file that will execute whenever a file in the subdirectory is browsed - or, at least it is executed the first time a file in the subdirectory is browsed.
When we send a mail using the code below,we do not get simplified chinese characters if they are present in the body but we get junk in the mail and we need to change the mails encoding to simplified chinese to see the Chinese characters.
'CDONTS object
set objMail = Server.CreateObject("CDONTS.NewMail")
objMail.MailFormat = 0
objMail.SetLocaleIDs(65001)
objMail.From = sFromEmail
objMail.To = sToEmail
objMail.Subject = sSubject
objMail.Body = sMessage
objMail.Send
set objMail = Nothing
I got a problem while running an application. The code for this is as follows:
aList = Split(strMsg,";")
For nX = 0 to UBound(aList)
strarry=split(aList(nX),"_")
var_year=left(strarry(2),4)
var_month=mid(strarry(2),5,2)
var_day=mid(strarry(2),7,2)
var_date=var_day&"-"&var_month&"-"&var_year
var_time1=mid(strarry(2),9,2)
var_time2=mid(strarry(2),11,2)
var_time=var_time1&":"&var_time2
set rs1=conn.execute("insert into tbl_BackupfileInfo(Filename,Createddate,Createdtim e)values('" &aList(nX)&"','"&var_date&"','"&var_time&"')")
Next
while runnig this application some times it works fine .But some times it giving an error
Error Type:Microsoft VBScript runtime (0x800A000D) Type mismatch: 'UBound'.
I have written an ASP.NET 2.0 application that uses Active Directory or ADAM
to manage account users - the site has a page that allows people to create an
account (much like any site). The page populates the AD with all the
information and the user account but I am unable to enable the account.
Microsoft has information on how to do that here -->
http://msdn.microsoft.com/library/d...ting_a_user.asp
(the sample is for Visual Basic) - and I am unable to complete the bottom
portion of the script. Can some one point me in the right direction - or can
you tell me how I can add a snippet of VBscript code to an ASP.NET page.
I am using the Active DS Type library - not sure why there are multiple ones
(System.DirectoryServices) but it is rather confusing - I seem to accomplish
one thing with one and another with the other (they did have trouble
co-existing however). Anyway my script works very well but I am not able to
access the properties required to enable the account.
Here is a simple version (no error checking) of the code.....
how to go about setting up an asp script or flash action script to take the input from a user of his/her username and password then send an email to the user with the information. I am able to do all of this but the problem is that the users pc is the one sending the email. I want the server to send the email instead.
View Replies View RelatedI am trying to send a fax from my asp application and am getting the follwoing error on the hghlighted line:
Error Type:
(0x80004005)
Unspecified error
If anyone knows why..Code:
I have a table with four fields, ID (auto increment), question (varchar(200)), answer (Text), and shop (tinyint(3). When I connect to the database in an ASP page and write this code
Response.Write rs("question") & "<br />" & rs("answer")
I get an error that reads "Type Mismatch"
but if I change the type of the answer field to type varchar I don't get the error but am limited in the length of the field's contents. I just also noticed that if I keep the type at TEXT and change the collation to ascii_general_ci I don't get the mismatch error but all the ' characters turn into ? characters? Oh woe is me.
I was looking for an app that i could use as a glossary, though i'm not sure how you would refer to it.
Basically, something that has 0-9 and A-Z with a search feature, by hitting G, all the items starting with G would appear, etc.
I am moving a mySQL db from one server to another. My backup sql is coming from phpMyadmin and I am using another 3rd party db admin program on the server. I am copying and pasting this code:
View Replies View RelatedI have an access database, with a form field "scores", which is a text field. This is the code (i have included the database code in the script btw):
<%
Dim scoresql,scorers
scoresql = "SELECT * FROM users"
Set scorers = conn.execute(scoresql)
Do
scores = Split(scorers.fields("scores"),"~")
Response.Write(scores)
scorers.movenext
Loop while not scorers.eof
%>
I can't tell what's wrong.
if you can I am getting this errror:
Microsoft VBScript runtime error '800a000d'
Type mismatch: 'FormatDateTime' /bb/aspBoardDetail.asp, line 57
<tr><td><font face="<%=abFont%>" size="-1">When: <%=FormatDateTime(adoRs.Fields("msgTime").Value, 2)%> <%=FormatDateTime(adoRs.Fields("msgTime").Value, 3)%></font></td></tr>
After about 30 minutes of frustration I finally discovered what was
causing a general 500 internal server error and to my surprise it was
something I seem to always take for granted for its simplicity. A type
mismatch error trying to compare a string to a numerical value, which
is something that PHP has no problem or qualms with. However, this
continuous problem continues to haunt me year after year and has
brought me to tears with frustration. This is the line that raises the
error:
nID = Request("ID")
If IsNull(nID) Or IsEmpty(nID) Or nID = 0 Then
.... (and so on)
In the past I've written a function 30 lines long that compares values
by confirming value types of the variables first, but I would rather
put a gun to my head than do that. Since there are obviously other
bright PHP and ASP developers out there that constantly trip over this
problem, I would like to know your suggestions or methods of working
around this.
I am new to ASP programming and I am trying to get an existing website to work.
I have created the following function to get the day:
function nrDate()
nrDate = DAY(Date())
end function
But when I use the page it gives the following runtime error:
Microsoft VBScript runtime error '800a000d'
Type mismatch: 'DAY'
I have googled the problem for hours but cannot find anything that may be helpfull. Does anyone have any ideas because this is getting quite urgent and I cannot move forward without this function.
Microsoft VBScript runtime error '800a000d'
Type mismatch: 'getTableFields'
Line is commented.
set exclusions = Server.CreateObject("Scripting.Dictionary")
exclusions.Add "id", true
exclusions.Add "timestamp",true
set tableKey = getTableFields("CIL_Addresses",exclusions) ''''TYPE MISMATCH ON THIS LINE
May be helpful to see getTableFields()
Code:
Any Idea what this might mean?
Microsoft VBScript runtime error '800a000d'
Type mismatch: '[string: ""]' /App/Director_Appraisal_Results_Saved.asp, line 444
Does anyone know this type of error means?
Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC Microsoft Access Driver] Could not use ''(unknown)''; file already in use.
/asp/PPLMain/memberpage.asp, line 10
and in my line 1o is
RsMember.ActiveConnection = MM_connPPL2_STRING
This works before but then it went like this. Anyone can help?
I am receiving the following error:
Type Mismatch '[String ""]'
Here is the code that the error seems to be referring to:
For i = 0 To UBound(Duties)
dblTotal = dblTotal + Duties(i)
Next
Do I need to convert these variables to Integers?
How do I set the Files of Type to only jpg extensions from this <input type="file" value=".jpg" name="File1" size="20"> the red above wont work.
View Replies View RelatedI use Server.CreateObject("MSXML2.ServerXMLHTTP") etc to grab the content of
another asp page.
I want the other asp page to look like an xml document. So I set the header
to text/xml with the line
response.contenttype="text/xml"
I set this on the calling page and the page that is called.
When I view the headers with http://pgl.yoyo.org/http/server-headers.php it
is still set to text/HTML. Also the browser displays the page as if it were
HTML, not XML
What data type do you use for this input -- uyen8976? how do you convert it to a string? how do you query it?
I tried to create a table in sql with this field
invoice char not null
inv=request.form("inv")
qInvoice= "select invoice from ItemMaster where invoice=" + cstr(inv)
rs.open qInvoice, "dsn......"
when i tried to query this field, computer didn't understand what cstr(inv) was. It kept reporting errors.
However, i couldn't use varchar data type for uyen8976 either. The computer didn't let me convert "uyen8976" into a string.
I pass session variables in a querystring to another page, which increments an array and adds them to it. This had been working absolutley fine on my local machine and I uploaded the scripts to a remote server. Everything worked fine (and still does) on the remote server.
I then decided to try opening the script that receives the querystring in a popup with javascript window.open, to display the results in the popup instead of a full new page as before.
When I tried this I got a Type Mismatch on the receiving page. I hadn't changed any of the code in any of the pages apart from calling the receiving page with window.open, so I thought it just didn't like being called/opened that way. So I removed the window.open and went back to the old way - and I still get the Type Mismatch.
I couldn't see why it was throwing this now, so I downloaded the scripts from the remote server (which work fine) to my local machine and I still get the Type Mismatch on the local machine. I tried stopping and starting IIS and then rebooting, but to no avail. It still works remotely but not locally.
The mismatch is occuring apparently between the String I'm trying to add to the array and the array index (which is also a session variable): Code:
i am getting a type mismatch for a page i am trying to write. Code:
View Replies View Relatedi'm getting a type mismatch error
conn.Execute "DELETE FROM Bmemo WHERE (tDate <= '" & date() & "')"
tDate is a date field in an Access database
Like so many, I will preface my question by saying I'm a complete ASP noob. I am however very experienced with PHP/MYSQL so I understand the concepts, it's just a syntax problem.
I have the following:Code:
sqlGroups = "select groupName from Groups where groupID = '" & rsParts("groupID") & "'"
set rsGroups = Server.CreateObject("ADODB.Recordset")
rsGroups.Open sqlGroups, strConn
response.write(rsGroups("groupName"))
This is resulting in a type mismatch error. rsParts("groupID") is from another recordset in the script, of type Long Int. groupID in the Groups table is autonumber, also of type Long Int.
I am currently taking a lot of web form information and compiling it into a word document for users to download; however, I want to be able to embed any attachments
that they have inside the word document. The attachments are coming from a database and the office suite does not reside on
the server. Does anyone know if it is possible to create a word document with embedded attachments for download.
Guys i tried this
sqlstr= "UPDATE BorrowerTab SET BorrowerName = '" & strName & "', Email = '" & strEmail & "', Phone = '" & strPhone & "'"
I get the error
[Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable query.
I think the problem is i need to have a WHERE clause in my sql statement
The thing is i dont know how to...
Cuz the field is an auto number(BorrowerId)
One ASP page doesn't throw a type mismatch error and the same exact code in a second ASP page throws a type mismatch error.
I simply throw a Cdbl around my variables and it clears the error, but i'm getting a new one today that i didn't get yesterday on the second page. Again, putting a Cdbl around it... Why is this page being so particular?
I have verified that the info from my submit form with the datbase and have figured out it has something to do with my database. When I dont fill out a certain field on the form like LoanAmount it gives me that error.
In my database the field type is set to currency and no required with a default value of 0. If i change the field type to text it works if I dont fill in the LoanAmount field, but I dont want to change it to that . Any suggestions? I want to be able to not have to enter info if not needed into certain fields and still be able to submit the rest of the info. here is my submit page: Code:
i receive this message when i try this code,
Microsoft VBScript runtime error '800a000d'
Type mismatch /33259/insertproduct.asp, line 42
Code: