Simple Query
I want to display a message if the submit button was pushed on the same page.
<% If Request.form("submit") = "Submit" Then
Response.Write "Your photo was successfully uploaded."
END IF %>
The action of the form is the same page. Code:
View Replies
ADVERTISEMENT
I'm trying to figure out why some of my queries are timing out on me. Here's the setup.
Page
Pop-up window with drop-down menus and 1 iframe. Top section loads 1 time.. any search or changes in drop-down menu is transfered to the IFRAME by changing the source.
I notice if I have a total number of records not greater than 1000, this choosebox works just fine. If the total number is greater than 1000 then it's 50/50.
Problem
When I do a search or change the value of "Sort by" or change the value of "146 - 257" the application times out. I believe the timeout is set to over a minute. I look on the server and I see that DLLHOST.EXE is taking 50%+ of my CPU.
I tried the same query in SQL Query Analyzer and it pulls the correct records in no time. I also have a TEST QUERY page in the application and tested the data there and I get the correct records with no timeouts.
View Replies
View Related
i have written some asp code on onclick of one button ,purpose is doing those work without submitting main form ,I am not getting working as files are not getting uploaded on web server any syntex error ? do u think this is write way to do so or suggest and modify code:
View Replies
View Related
A system I use uses advanced encryption for passwords. It was taken from some sample script and adapted some where. However this was I think intended to be for passwords. So nothing too long.
However the time has come where I need to create a function to encrypt a large amount of text. It has to encrpt a large amount of text but nothing too advanced is needed to be honest. Just so its unreadable because its written to a text file on drive. It has to be a function though then capable of decrypting the encrypted text.
Any ideas ? Again Dont have to be nothing too flash. I mean I had a go at just changing letters to different letters but the function got huge with all the replaces.
View Replies
View Related
My code retrieves a username and a password from a form. Then this information is compared to some usernames and passwords that are stored in a database. The important thing here is that the comparison must be case sensitive meaning that "passWord" is not the same thing as "password"
I have this code, working fine in access 2003
SQL = "SELECT * FROM users WHERE StrComp(username_column,'" & entered_username_in_form & "',0) = 0 AND StrComp(password_column,'" & entered_password_in_form & "',0) = 0"
but get the following error when I run it against my sql 2005 database.
[Microsoft][SQL Native Client][SQL Server]'StrComp' is not a recognized built-in function name.
I don't know the corresponding t-sql for the query.
View Replies
View Related
I am running a querry on an access database and have set the number of records/page displayed at 20. if there are more than 20 records returned, then 1st page will show the first 20, the next page will show next 20 and so on....
The trouble:
the count of total records displayed is correct and the first page is displayed correctly. But when i click on *Next* to go to the next page, all the records of the database get displayed (not the 2nd page of records from the query).
View Replies
View Related
I am using ASP/MS ACCESS to see how I can query the same database, via 2 formfields.
{name: - search}Textfield 1: - Search by Category
AND/OR By
{name: - searchT}Textfield 2: - Location
Currently,
strSearchwords = Trim(Request.QueryString("search")); where "search" is the name of Textfield1
Which is fine, but how can I set it so that on Submit, the string from search, and searchT are somehow joined together into one string?
View Replies
View Related
i have 3 fields like these
membershipamount=100.00
Postage=15.00
GiftArticles_Amount=5.00
and i add them up to get the totalcharge like this
Total_charge=Int(membershipamount) + int(Postage) + int(GiftArticles_Amount)
so i get Total_charge=120.00 which is what i want
but when i have like this
membershipamount=100.00
Postage=15.00
GiftArticles_Amount=3.50
i get Total_charge=118.00
View Replies
View Related
does someone know a good site for asp 3.0 interiew questions
View Replies
View Related
I have only begun to look into ASP due to an assignments requirements.I usually code in PHP,one feature in PHP is to be able to do an if.else statement,where if a certain statement is true then a chunk of HTML can be outputted.
Basically I want to be able to do this in ASP to use with a simple authentication system which I will construct.I have just got a fat book on ASP,and am beginning to read through it
View Replies
View Related
I am not an ASP programmer, but I need help with the syntax. I have a simple if/else statement that I need to translate into ASP. Begin Pseudocode
if
{
(id == 1,2,3,4,5,6),
then print "Private"
}
else
{
Print <a href="https://www.mydomain.com/file.asp?ID=<%=rs("ID")%>" target="_blank">Register</a>
}
End Pseudocode
So how do I say this in ASP?
View Replies
View Related
i'm trying to create just a simple upload - fill in a form with the article
title, and description - and select a file - i need to upload that file to
the webserver, and then rename that file to the <% =Sartid %>.pdf
any ideas where to get something this simple from? never done anything like
this before - i'm guessing the FSO will be used?
View Replies
View Related
This code is working partially fine
<%
sch = "http://schemas.microsoft.com/cdo/configuration/"
Set cdoConfig = Server.CreateObject("CDO.Configuration")
cdoConfig.Fields.Item(sch & "sendusing") = 2
cdoConfig.Fields.Item(sch & "smtpserver") = "mail.aws.no"
cdoConfig.fields.update
Set cdoMessage = Server.CreateObject("CDO.Message")
Set cdoMessage.Configuration = cdoConfig
cdoMessage.From = Request.Form("E-Mail")
cdoMessage.To = Request.Form("sendto")
cdoMessage.Subject = "Tilbakemelding fra nettsiden"
cdoMessage.TextBody = strBody
cdoMessage.Send
Set cdoMessage = Nothing
Set cdoConfig = Nothing
Response.redirect Request.form("resulturl")
%>
Well, this works with only some addresses and not others.
Examples:
bjorn@domain.no
b@2.com
will work...
On the other hand:
bjorn.kaa@domain.no
bjorn-kaa@domain.no
won't work at all...
View Replies
View Related
I need to send data from a 'form' on an HTML page to an ASP page.
The ASP page should 'return' a simple HTML page containing
the data from any items submitted, including any hidden items.
View Replies
View Related
A user logs in, then based on their account (username/pass), they are redirected to a specific web address.
I only need 3 different accounts.
Can this be done with Javascript? Or do I need to use a database?
If you can point me to some script that will achieve this I would love it!
View Replies
View Related
I got a small problem that I think you can solve in a sec.I use ASP to tell day, date, month etc on this page:
http://www.aljapaco.com/award/nyawar...rd&val=purpose
But,as the servers is in Sweden and I´m in Sweden to, I see the text in Swedish.
Can anyone that lives in any other country just please tell me if the text is in English when youre not viewing it from a Swedish connection.
IF it´s still in Swedish, how (if) can I make it change to English text or am I stuck with some messy old Java Script??
View Replies
View Related
does anyone know of a good place to find code samples for ASP Simple Upload. I can't seem to get to the original site.
What I need to do is upload the file and save the path and some other info into to a database.
View Replies
View Related
I have a stylesheet switcher which store the user style preference in a cookie, however how do I modify the following to use the default stylesheet of “styles.css” if there is no cookie on the users computer? Code:
View Replies
View Related
Ok how do i update based on 2 Where options
i know this is wrong but i don't know how to do it.
strSQL = "UPDATE [Job Contract Assignments] SET currentassignment = 0 WHERE cnum= '" & cnumqs & "' "&" WHERE currentassignment = -1"
SQLconnect.Execute(strSQL)
View Replies
View Related
can someone tell me whats wrong with this code.i applying the style in right way
Code:
<tr style="background-color: #386cae; color: #000000; a:link {color: #000000; font-weight: bold;}
a:visited {color: #ded9dd;} a:hover {color: #000000; font-weight: bold; decoration: underline;}">
View Replies
View Related
i have a shopping cart type system where a user adds items to their cart, and as they are doing this, i have a textbox for the user to enter the quantity of the selected item they want!i want this textbox to be max. 3 characters in length (for asthetic purposes!!) but no matter waht width i make it, it is always displayed much bigger(longer) than i want! So how do i force this
textbox to be no more than 3 characters in length?
View Replies
View Related
I want is to have my asp code test if it is the first time the page has loaded. If so it will need to skip my validation info, if not then run the validation code:
View Replies
View Related
I've agreed to help a friend with a free project and everything was going fine until they got some free web space from another friend. It's running on windows and everything is ASP. I have never been near ASP and I really don't understand much. I use PHP/apache and even then it's only tinkering.I was hoping to find a simple script I could plug in and use as a contact form and one for a mailing list (both form to mail type things). But I can't. I've eventually managed to find a couple but I coulnt'd make any sense of them or get them to work.
View Replies
View Related
I have a form that only has one check box in it for active / inactive. This form is when viewing a member record. My 2 questions are:
How do I get the checkbox into the form showing the state that it is in the database? - I can get a check box to show, but can not get it to show ticked / not ticked according to the database Code:
View Replies
View Related
I have a database (*.mdb), which I can connect to, query on, and return results from in ASP. Now, I want to do some ADDs,UPDATEs,and DELETEs.... but I get errors executing my SQL... What's the trick?
PS My connection (thus far) is this, and works.
Dim Conn
Set Conn = Server.CreateObject("ADODB.Connection")
Conn.Provider="Microsoft.Jet.OLEDB.4.0"
Conn.Open Server.MapPath("myDatabase.mdb")
View Replies
View Related
I have this little flash movie on the main page of a website and I want to set the cookie so that when user first enters the site, the flash plays but when the user browses around and goes back to the main page, the flash movie won't repeat again ... kinda like ........ they can only see the movie 1 time when first entering the site but after that they won't be able to see it again unless they clear their cookies from their computer
View Replies
View Related
how can get simpleaspuploader for free.
View Replies
View Related
I am trying to add my numeric fields together to produce a total. Does the following make sense to anyone? Code:
View Replies
View Related
I'm currently creating a site that involves people with very little computational skills, proficient only really in word processing, submiting various technical documents to be uploaded to the website.
Because of the generally well-structured outline of these technical documents, I am going to store them in either a relational database (such as MySQL), or in XML form, or both. However, the problem is that most of these documents all ready exist in MS Word (.doc) format, and the documents to come in the future will also be created using Word by the aforementioned people.
I am going to make a simple, online content management system using either PHP or VB.NET (dosen't really matter to me), and I want these people to be able to upload a Word document, and have my CMS script automatically convert the .doc (or rtf rich-text, whatever's easier) into a simple, straightforward xml, similar to DocBook or something (not like Word 2003's incredibly complicated xml). Does anyone have any recommendations on how to go about doing this?
View Replies
View Related
I need to know the equation to pull back the sheet name of the sheet i am working on in excel ....
View Replies
View Related
I want to do a simple hit counter but my problem is I don't want to open a database everytime there is a hit. (I'm afraid this will give me problems with the server if too many people hit at once.)
I thought of doing it with files but I want others to be able to see the hits without ftp access.anyway to use javascript to call a stored procedure(in this case at least the page won't fail if the db is too busy)
View Replies
View Related
I'm trying to make a loop but can't get it right.I'm trying to loop through a HTML table with one row and five columns and search for a specific value, but since tablecells are not objects I don't understand how to do it.
View Replies
View Related
I want to create a simple menu with four buttons that when each one is individually clickec it sends you to a relevant page/submenu.
View Replies
View Related