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:
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.
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?
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"...
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:
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.
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.
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 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:
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
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.)
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.
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:
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:
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.
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:
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.
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).
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
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
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?
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!
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??