Simple Form Query
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
ADVERTISEMENT
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
View Related
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
Let's take this for example:
<form action="" method="post">
Firstname: <input name=""frmFirstname"><BR>
Lastname:" <input name=""frmLastname"><BR>
Email" Address: <input name=""frmEmailAddress">
<input" type="submit">
</form>
what i want to do is to show a Javascript Alert Window when the user enters a blank field and when the user enters an invalid email format.
View Replies
View Related
Ive searched the net, and ive had difficulty trying to get CDONT to work, nor "Server.CreateObject("SMTPsvg.Mailer")". I have my own server, and am using Windows set up. Perhaps theres a different type of script out there, and reasonably simple to run?
View Replies
View Related
i am creating a survey type page in Visual Studio it has 2 textboxes and 2 dropdowns and a submit button.
all i need it to do is when i click the submit send this data to an email address. The email address will never change so...
View Replies
View Related
I am using ASP, but javascript will be fine, basically I am looking for a very simple validation which will check the field below named= "LotAmount"...
<form name="bid" action="http://etc,etc" method="post">
<input type="text" name="LotAmount" size="9" maxlength="10" value="£">
<input type="Submit" value="Bid" name="Lotsub">
Here are the limitations etc I would like it to carry out: Code:
View Replies
View Related
I have a form, and it has an email and phone text input fields. I want to test if BOTH are empty and stop the email from being sent. I thought that this would work Code:
View Replies
View Related
I am trying to get a form to insert info into a access database. I am using dreamweaver 2004, i created the form with 4 text fields and a submit button. Ive added a ODBC connection and dreamweaver can qurery my table.
I added an insert record server behaviour, and i figured dreamweaver does all the work for you but when i saved and uploaded the page to my test server it would not submit and redirect to my chosen page, it only refresh the form.Has anyone out there done this before and can notice a step that im missing. Do i need to setup a recordset? because ive tried that as well and no success.
View Replies
View Related
i have a database and the asp file. my database will have one table, a user table, with various fields like username, password, name...age.. all i need is the html code to make a simple form such as
Welcome to the add user page:
PLease enter a username (input box)
Please enter an email address (input box)
finally a submit button.
i then want the variables to run a 'signup.asp' file which i have, and be placed into a database.
View Replies
View Related
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
View Replies
View Related
I have 2 databases, one i write two when i submit the form, that works fine. The other holds contact info. I need for when the Company Initials are typed in(form CSN) that the Pace Administrator info fills automatically(PAName and PAPhone). Code:
View Replies
View Related
How can I get this line to work? I am trying to get the results entered in a form to be part of my query. I am able to get the form results but I get a error stating Syntax error (missing operator) in query expression 'Assignee = Tom Jones'.Below is the line where the error occurs
Session("dbWhere") = "Assignee = " & Request.Form("assignsearch")
View Replies
View Related
I am trying to use form input (like text from a texbox) in a SQL query. So that way a person can enter a value in a textbox and hit a button to check for that value in a database. I have the connection to the database working fine its just passing that form value into the SQL string. I wish the SQL query would work like this:
SQLCommand = "SELECT * FROM dahliaSchedule WHERE scheduleDate= " & txtDateValue
where scheduleDate = (a value from the textbox from the form.)
View Replies
View Related
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.
View Replies
View Related
I want to add two buttons to my page, which direct to and send query information to different result pages.
View Replies
View Related
just manged to get an image retireval search engine working. The ASP script works fine, my query results are filepaths of images.
i structured a query in within asp to obtain images which have similar textual values. It is more of a cosmetic issue. when i get my query results back, my script prints or displays the images from top to bottom. which means i have to scroll vertically up and down the asp page over 10-30 images. Code:
View Replies
View Related
I have the following code that pulls a record based on a form submittal then populates a form with the fields so the record can be updated. My problem is in my query line more than likely in my keyset types and what not. 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
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:
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