I'm developing an account lookup, mostly in ASP, that displays a list of radio buttons to select one account from those found in a recordset. Here is a snip of the account display, after the recordset is populated: Code:
View Replieswrite a simple function to check the user input from a form. I need to check that the string contains only numbers, has a maximum leght of say 15 and that the first number is zero.
View Replies View RelatedMy site web is using database in ACCESS. I'M using a Table and a Query, the table work fine but the Query don't work.I got the error : Undefined "NZ" function.
I did some search and found that when query are used, it use a function "NZ" to replace NULL with " ". But ASP can't use that. It's what I understood.
I found some code to repair this but they modify my Database, and I don't think I should do this because maybe it could crash it.Somoene know how to get ride of this with out modifying the DB?
Was thinking of having an array inside a asp page. I'm rather new to this.How do I begin. my asp page should work as follows.One html page include mail adresses. We receive a lot of junk mail and I was thinking of how to avoid this. Was thinking of creating a asp page with an inout string inside the asp page. The input number should refer to the users mail adress.
We are only four people in our office, so that should be simple to manage.The html code should be like "redirect.asp?" for the first mail adress. and redirect.asp?What's the syntax inside the asp page?
is it possible to put an ASP function inside the javascript function?
e.g.
<script language=javascript>
function sample()
{
<%
here goes the asp code
%>
}
</script>
I'm trying to use a variable like a file and I do not know if it is possible, like this:
varfunc=chr(60)&chr(37)&"function addone(varint) : addone = varint + 1: End function"&chr(37)&chr(62)
Now I have a addone function inside varfunc.
The value of varfunc is <%function addone(varint) : addone = varint + 1: End function%>
Is it possible I use varfunc like a file or something to make the function active? There are some operator like a pointer to variable or somehow to eval like a code block?
I have a function that I'm using to loop through some db query results and put them into a table. Inside the function, I have a line to add certain values to a series of cookies (kind of like a cookie array) as such:
response.cookies("sclot" & ZZ) = LotNum
'response.write(request.cookies("sclot" & ZZ))
If I uncomment the second line, I pull my values just fine from inside the function. The problem is, if I use the exact same line to try to pull the values outside of the function, or from another page, it returns nothing. The whole reason I'm putting these values into cookies is so that I can pull this list up on another page, but I don't seem to be able to. Is there some reason that I would not be able to read a cookie that I set inside a function outside of it?
I have a function that I would like to use a session variable in. However I am not getting it to work out. I was wondering if you have define global variables inside functions like you do php or if something might be causing this?
View Replies View RelatedCan I define a function inside a function. e.g;
function abc()
function xyz()
....some code.....
End Function
End Function
I googled this but can't find any related topic.
So far I've been using Sets to read information from the database (Set RS = Server.CreateObject("ADODB.RecordSet") and RS.Open queryString, Conn)
I've got a situation now where I have a function which returns just a single value. I call this function using "SELECT myFunction(parameters)". I can't use a result set to retrieve the function return value, can I? How should I do it?
I have a form which consists of Iframe
<Form method="pst" action="test.asp">
<iframe src="testingframe.asp" id="testfram" frameborder="1"
scroll="auto">
</iframe>
</Form>
testingframe.asp has
<table>
<td>
<tr>
<input type=checkbox id="checkedName" name="checkedName"/>
</tr>
</td>
</table>
How do i acess checkedName value in my main form .... ?
i am unable to figure out some way....so pls if anyone has implemented then do suggest me. i need to have a link on clickign to which i want excel workbook to open (a previously created template) below the link in the form.
how can i do it. i find lot of info on opening excel as an application freshly. i want to
open in the form itself. is it feasible or i am just wasting my time searching info for it.
I have a form in asp that has a drop down of contact - busness names. One side is contact name and other side is business name in this one drop down. I want to create a button or Link for the user to click and re-sort the order of the drop down from contact name to business name. The drop down is in a form already, so I thought about using another form inside my main form to run a requery of the drop down, but I don't think I can run a form inside a form...
View Replies View RelatedI have an ASP application which gathers information to put in a
database via some forms - I would like to do the form validation
(making sure some fields are not empty) with a Javascript script inside
the ASP file - what is the syntax for doing this? Usually I would place
the javascript inside the <head> tags, but ASP files don't have
those.
i have an ASP page with a table that is populated by a db query the table is set in a form(outter form) so that a user can up date and add information to the table. one of the columns is a form(inner form) to us a buttont to call an asp function to generate a random number (invoice number).
The problem i am having is that when i click on the button (inner form) to generate the invoice number it wants to load the page for the outer form. how can i fix this? If you can tell me how to call the asp function with out a form then great. I am open for options. What I am trying to do is have a button (invoice #) you click and it is replaced by the random number that was generated.
How can I create a query based on the form input. I want to have a pulldown menu (list of states). The user can select the state, lets say VA and click on "go" button. I want the page to return results that has state=VA. So how do I create that statement and send to aspx ?
View Replies View RelatedI want to have a form like a table of record. If I let user input number of record to be insert in advance, how can I make a form that having number of rows of input? For example:
Number of records : 5
Then I need a input form like a table with the column and 5 row like Excel format.
The form:
Title Row : No. | Dept ID | Emp ID | Base Salary |
Input Row1 : 1 | | | |
Input Row2 : 1 | | | |
Input Row3 : 1 | | | |
Input Row4 : 1 | | | |
Input Row5 : 1 | | | |
I'm thinking all my input will be array. Then when user submit I'll split it and insert to DB. Code:
I have been ask to try a create a form on my works website to allow
teachers to fill it out the click button that emails to the boss
I thought asp is what need so i am very new to asp and with a lot of reading
from the net and books i got it to work :) but i tried to get too clever and
sent the user info to a page so the user can check for errors before
emailing but i cant figure it out and by fiddling too much i have stuff it
completely
can it even be done input info into form post that info to a new page
and then if the info ok email
i've recently done a basic website offline and haven't uploaded or found a host server yet. however i was wondering if there is a way to process the form input offline. I was told i need ASP functionality. but i'm not too familiar with it.
View Replies View RelatedI have a form which inputs info into a database. However what I would like is to populate a select box directly from the dbase. When the form is entered the field is updated along with all the other info.
I have enclosed two of my pages - I think I'm nearly there.
I've got a form inserting some data into the DB.
When I try to insert data with "'" in between, say Dummy's.
I get an sql syntax error.
Heres my code:
strTitle = CStr(Request.Form(txtTitle))
sql_insert = "INSERT INTO db VALUES ('&txtTitle&')"
I can insert any data as long as it doesn't have "'".
Is there anyway I can go around it?
I am designing a website for a friend that has a backend database that holds information on all the stock they have and this gets displayed onto the page no problems.
The only problem I have is when they add new items to the database, a part of the form is a textarea and in this teaxtarea they copy generated code from paypal (a form that is generated by Paypal as a add to basket button).
The problem I have got is that if you try to add this textarea to the database field what you get is a image of the paypal button and no code.
I have tried the replace function, concatenated it in comments etc but all i get is a blank field or a image of the button.
I have a HTML page with a form on it. I have an ASP page that processes what a user has entered into the form (updates a database etc).
I now need a page that fits between these two pages to pre-process�the users input. I need to do it this way because I am not allowed to change either of the two existing pages.
I know how to read what the user has input into the form and I know how to pass control onto the next page.
What I have not been able to work out is how to change the user input and have those changes passed onto the next page as if nothing has happened (that is, the original ASP page just performs its request.form(�item�) calls as it always has but instead of seeing what the user actually typed in, it should see the changed text as created by the new pre process� page)
I have tried using a regular expression replace but can only successfully make this change a variable and not the original form input. Equally I cannot find a way of swapping the original form input string with the output variable from the replace.
Does anyone have any ideas on this one?
i have fixed my code and there was no error at all, it executed well and the msg "The quote has been sent" appeared. But although it was working, but it seemed that it didn't really sent the Firstname and Address to the email. Why? here's my code :
View Replies View RelatedI'm working on a form where the user is not required to fill out every text input. How mught I check for that in an ASP script. Here's what I have:
If Request.Form("mp3title1") == ""
amnt = 0;
Else If Request.Form("mp3title2") == ""
amnt = 1;
Else If Request.Form("mp3title3") == ""
amnt = 2;
Else If Request.Form("mp3title4") == ""
amnt = 3;
Else If Request.Form("mp3title5") == ""
amnt = 4;
End If
Pretty straight forward, its checking in order if the first element is left blank, is the correct technique:
== "", or is there more to it?
how do i allow the user to add in a value that has a ' in it (e.g int'l) apperantly if i do that there will be an error... how do i go about this?
View Replies View RelatedI want to send the data from a user's form input in an ASP email. For instance, shen the user submits their name and email address on a form, I would receive an email with those fields mixed in with a plain text message. How can I do this?
I have programmed extensively in other languages, but not ASP (our company is switching from ColdFusion), so I will need my answer in fairly introductory ASP terms.
How can I specify formatting restrictions for special fields like Postal Code
(format X1X 2C2) or date input field MM/DD/YYYY? I have Acces DB with these specs, but when I used FP2002 Database Interface Wizard, it ignores these. Also I am unable to "edit" any of the records utilizing pages generated by this wizard.
There is an error that it will not accept empty fields. I have no problem adding data (even if some fields are empty) or deleting records.
I have a form, where the user types their initals and it then returns some results. However, the Oracle database requires the initials to be in capitals, how can I convert the user input to upppercase?
View Replies View RelatedI'm reading data from an XML form and prepopulating a FORM. For the text inputs I have no problem prepopulating the Values from the file...
document.forms[0].elements['FormName'].value=xmlObj.childNodes(0).childNodes(0).firstChild.text;
But one of my fields is based on input from a radio input (three inputs with a value of 1,2,3). Since they all have the same name using the code above will not set they value for any of them. Anybody else run into this, or have a suggested way I should do this.
I'm trying to create an input screen that allows users to create a hierarchical structure as the one below, but have no clue where to start or how to construct it. Code:
How to search a database field from form input? is it easy to do i like to have a html form from an html page that will call an asp page to do db search, if user enter a zipcode that match in the database it will pull all the infomation from both talbes and display on the screen
i have 2 tables related to each other
contact table
id, fname, lastname, contactid, email
zip table
id, zip, contactid, city
How to search a database field from form input? is it easy to do i like to have a html form from an html page that will call an asp page to do db search, if user enter a zipcode that match in the database it will pull all the infomation from both talbes and display on the screen
i have 2 tables related to each other:
contact table id, fname, lastname, contactid, email
zip table
id, zip, contactid, city