I have a DB with a date field that is empty
Because of this the records sometimes get included in searches because their
contents are less than a particular search.
so..I had planned to populate them with any old date.
BUT I CAN'T!!!
I have tried all sorts..and nothing seems to work.. Code:
I have created a form that asks the user to select an item within a drop down list, once they have selected the item i would like it to populate one of the other fields with a code depending on which item was selected within the drop down list. How would i do this?
View Replies View RelatedI am using what seems to be a fairly simple calendar program that is ASP. I have been successful in adding fields to this App, but for some reason, I must be missing something because when I go into the program to edit an entry, one of the value's (Location) doesn't populate properly.
It pulls up the LAST option (Other) within that dropdown field, instead of the one that had previously been selected. I'm not sure what I've missed, but could someone help? Here is a portion of the code: (let me know if you need additional info). Code:
I am trying to retrieve the last value in my table in the ID column and auto input it in a field in my form when I open the form page (form.asp). This is what I have but it is obviously not working. ?
<%
dim Rs, SQL, conn, ID
Set rs=Server.CreateObject("adodb.recordset")
SQL = "SELECT TOP 1 ID FROM Table1 ORDER BY ID DESC"
Rs.Open strSQL, conn
ID = Rs.fields("ID")
end if
%>
<input type="text" name="ID" value="<% =ID %>" size="13">
Looking to populate an access db table 'ole object' field through asp code.
View Replies View Relatedi want to count all the records in my database where a certain field is empty.
heres my statement:
"SELECT Count(*) As Total FROM table WHERE field1='value' AND field2=' ' "
gives an error.
If it not possible. can the next be done:
1 count all the records.
2 count the records where field2='Yes'
3 subtract the two to get where field 2 is empty?
i know it's just something small, but i can't seem to figure it out. i also tried field2 != 'Yes'
I'm brand new to this forum AND learning ASP via problem-based learning (not the easiest or sound way to do so, I know).
In any case, I have a form that uploads an image to my server. It does so via a form action to a new asp page. The new page has a link back to the original page. On the original page, I want the name of the file to appear in a text field e.g. Code:
I'm listing records from my db and each company has 3 address lines ie address, address2, address3. In most cases 3 and sometimes 2 are empty. As my ASP looks like this
[VBS]
<p><strong>Address/strong> <%= rs("Address") %><br>
<%= rs("Address2") %><br>
<%= rs("Address3") %><br>
<strong>Town/strong> <%= rs("Town") %><br>
<strong>Post Code/strong><%= rs("PostCode") %><br>
<strong>Telephone/strong> <%= rs("Telephone") %>
[/VBS]
then I end up with the first line of the address and two blank lines. How could I avoid that by checking if the fields have content, only then display them?
I am trying to determine if a field in a database is empty or not. The code I have is this....
(before this I have code that opens up the database, gets the data from the table. the var "content" holds the data if any from the database.)
if content = "" then
alert1 = "content field is empty"
else
alert1 = "content field contains text"
end if
This doesn't seem to work. I also tried...
if (content) then
alert1 = "content field is empty"
else
alert1 = "content field contains text"
end if
No luck yet. Any ideas?
I so thought I had this down and I was getting excited, but when I ran it, it didn't work. I've tried a few different things and I can't get it to work (not smart enough I guess). Code:
View Replies View RelatedI know it should be very easy but I am new in ASP so I could not figured out.
Here is the simplified version of my code:
thePaymentID= request.querystring("IDValue")
SQLqueryPayment= "SELECT sum(paid) as paid, sum(Interest) as interest
FROM payment WHERE payment_ID =" & thePaymentID & ""
dim rstempPayment
set conntemp=server.createobject("adodb.connection")
conntemp.Open "DSN=payment"
set rstempPayment=conntemp.execute(SQLqueryPayment)
fldValPaid = rstempOwner.Fields("paid").Value
------------------------------------------------------------------------
I need to find out if "fldValPaid" hold anything. I will use it an IF ELSE statement. In payment table a particular record could exist or not. How do I find out by evaluating "fldValPaid" if any record exists or not. I have to find out using "fldValPaid" ...I can not use number of record/record return or any other method.
I've been searching for an answer to this for quite some time now and have found nothing, so maybe (hopefully) someone out there will be able to help me.
At my work, we have a lot of folders for different jobs we've done. And right now, we have more than one person making the folders for all the new jobs that we get. I am trying to make a database were it will only show the jobs that have not had folders made. In order to do this, I've created a field titled "Initials". I want the webpage to pull up all the records where the Initials field is empty, but I'm having trouble doing that. I've tried a few different things and have found no success.
I'm not having a problem accesses the database or updating it, just displaying the right information. I'll give a little illustration (because I'm never good with words):
Say I have 3 jobs: Job #1, Job #2, and Job #3. Someone has already made job folders for Job #1, but Job #2 and Job #3 still need to be made. Since Job #1 has been made, that means there are initials in the initials field of the database and thus, I do not want that Job being displayed on the "To Be Made" page. Job #2 and Job #3 do not have initials in the initials field and as such, I want to display those jobs....
I'm getting an error when I'm retreaving from a "text field" in the database and it has no data in it. I'm using MYSQL version 3.23.58-nt. I have the same script running a different system and I don't get this error. It justs output nothing and continues with the loop.
This has to be an ASP problem when retrieving data from the database. I've change the Field for Message to "varchar(252)" vice "text" in the database and stoped giving me error. But I still need to use the type "text" in the database since my "Message" will be longer then 252 caracter. Code:
I have an index.asp page that displays my database items, along with their respective categories. The categories are an include page (left.asp). How can I hide the category if there aren't any items for that category? Here are the 2 pages below....
View Replies View RelatedWe have an ASP site that hits up an Access database of categories of
products and products. (e.g. Categories = Napkins, Tablecloths;
Products = 20x20 Napkins, 21x21 Napkins, 54x54 Tablecloths, 60x60
Tablecloths)
We currently have select boxes that when you select a category, it
populates the next select box with the proper list of products (i.e. I
select Napkins as a category, I get a listing of the Napkins)
We would like to put a clickable link before each of these select
boxes that would pull up a pop up with links from the records from the
proper table.
(e.g. I click the categories link and a popup with html
anchor tags of Napkins and Tablecloths appear) I click on the Napkins
anchor and it populates the Categories Select box with Categories and
Napkins being selected.
I want my asp code(recordset) to populate a table structure like below...How will I do that ? I have the corresponding day(monday,tuesday,etc) stored in my db...This is a weekly schedule for all drivers..A sample db table output would be : Code:
View Replies View RelatedI am running it on IIS, access db, and ASP.
The user selects from several dropdown boxes, on different pages assessing different faults with a particular job. Finally it comes to the last page and displays all the various bits and pieces that have been selected along the way,
THE PROBLEM, ERR CHALLENGE....
It also needs to populate an email link to display the info selected and then which is emailed to an administrator for approval.
And then exported to excel format.
I have a form with a select control called "Last Name" and 1 text box called " First Name". In the select drop-down I have a list of last names pulled from the database. Also the second text box first_name value will be pulled from the database also.
When a user selects a last name from the list I want it to automatically update the first name textbox based on their selection. Ie. The persons first name is put into the textbox.I need to take the values of both(First Name and Last name) and send them to another page
I have an ASP web form that I want to populate fields based on the first
field choice. Example I have 4 fields item, price, delivery, availability. I
have all these items setup in an access table. When a user chooses an option
from the item drop down, the price, delivery, availability will then
populate. I have already made my connection to the database, and created the
drop down for field one from the choices. How do I now populate the
corresponding fields.
Im new to asp and I'm having trouble with listboxes.
I have two listboxes, the first is populated from a database and I need to fill a second listbox with items from the database that are dependant on what was selected in the first list box.
I've been hunting around the forums for ages trying to find a solution to this but no joy so far, hopefully someone can help?
Basically I'm a bit of a newbie to session variables, and was wondering if they are they best thing to use for the following problem I have;
What I want to do is capture a referral ID from a URL i.e. www.mysite.com?ref=1234567 and then store it in a session variable and if the person signs up for a service, it automatically places the referral ID in a text box on the order form.
Does anyone know if this is possible or know of any tutorials? I've had a good look on google, but no joy so far.
I think the key bit is how I capture the ID into a session variable?
I want to populate a dynamic schedule table M-Sunday like this. My db doesnt have a column called monday,tuesday,etc.
I want to create a loop that get the data from access then fill the cells for date and route..Any day may have 2 or more schedule.
I have this code which populates a multiple drop down
getedu=rs("Education")
when i do a response.write getedu the output is
Bachelor, PHD
then i use to select the values in drop down
and its not working any ideas why Code:
Which of the method is used. ? Writing an SQL statement in ASP to populate a recordset OR Calling a stored procedure to return records to populate a recordset. Which of the above two methods is more useful and faster.
View Replies View Relatedi have learned how to populate a webpage with images from a database. however, i would like to go a little deeper:
i would like to create a recordset (in dreamweaver) with a drop-down list of my product lines:
product line A
product line B
etc
etc
this is not a problem. i can do this. however, once the user has selected from the list, i would like the corresponding images to be displayed in the webpage. i am not sure how to go about this. tips for doing this in dreamweaver would be excellent.
I have two form items listbox 1 and textarea 2 and a button. I populate the listbox 1 with a SQL query. i want to add the following functionality:
i choose something from the listbox push the button and then the selected item must appear in the textarea( or listbox ) when i choose a second item from the listbox it must appear beneath the first choosen item etc.
i have already populate a list from my database using the following code . Code:
<form method=post action="ProcessOrder.asp">
<select NAME="TEST">
<% Do while NOT rsHis.EOF
response.write "<OPTION VALUE=' " & rshis("pic_id") & " '> "
response.write rshis("title")
rsHis.MoveNext
loop%>
</select>
But i dont know how to present the results from the combo box.
When the app is ran you get a list of checkboxes to choose from which passes values to crystal reports. All I need to do is change those checkboxs to dropdowns. Can someone give me some assistance here?? Code:
View Replies View RelatedI have a drop down menu that is populated from a database. the problem that I have is that alot of the numbers in the field are duplicated ie the field in question has years in it and may of the years are the same.
is it possible, when there are duplicated years, to populate the dropdown menu only once with that particular year. This would grately shorten the menu for me.
Can one form be set up to populate two or three tables? If so, how?
View Replies View RelatedI am trying to populate a dropdown box with 2 date variables called today date and tomdate. First it will show "-choose-", followed by todays's date and then tomorrow's date.
The selected date needs to be validated by my hidden function called Validate. This I can do, but I can't figure out the syntax for the dates. Following is another dropdown box which you can make the changes to so I can see the proper syntax.....
I have an array - ListOfFiles - that i want use to populate an combo.
I've attempted to do it like this:
<select name="txtAvailable" rows="4" id="txtAvailable">
<Script Language = "vbscript" Runat = "Server">
For i = 0 to Count -1
Response.Write"<OPTION>" & ListOfFiles(i) & "</OPTION>"
next
</script></select>
I placed the vbscript in the approprate place in the body. But when i
open the page instead of writing the HTML where i placed the code, it
has appended it right at the bottom of the page. Does anyone know
where i'm going wrong or if there's a better way of doing this?
I would like to populate a dropdown box with monthly names. Jan- Dec.
View Replies View Related