If you have a table on a website that is 3 rows across and 8 down, is there a way to copy code and then but your cursor in the first field and then paste data in each of the table cells?
The result would be rather than typing data in each cell individually, you populate the table with one paste.
sql = "SELECT [R.oriAddress], [R.oriCity], [R.oriPostcode], [R.oriState], [R.oriCountry], " & _
"[R.mobileNo], [R.homeNo], [R.resDate], [R.resTime], [R.surveyDate], [R.surveyTime1], " & _
"[R.surveyTime2], [R.moveDate], [R.moveTime1], [R.moveTime2], [R.destAddress], [R.destCity], " & _
"[R.destPostcode], [R.destState], [R.destCountry], [R.resType], [R.resStatus], [R.staffCode], " & _
"[S.staffCode], [S.staffName], [C.custName], [C.custIC] " & _
"FROM (Reservation R " & _
"INNER JOIN Customer C " & _
"ON R.custCode = C.custCode) INNER JOIN Staff S " & _
"ON R.staffCode = S.staffCode " & _
"WHERE R.resCode = " & id
i used sql code above to display data in a table. basically, the flow is like this. when there is a new reservation, a staff will be assigned to handle that reservation from the beginning until the end. before this, i just display a staffCode that retrieved from Reservation table.
then, i made changes to display staffName and removed staffCode from the table (based on requirement). but, because previously, there are some reservations that have been assigned to staff, i do not have any problem to view all data in the table.
but, when i click other reservations that have not assigned to any staff, an error page came out. the default value for staffCode in the Reservation table is null. because this null value, i've got an error page. is there any steps i can use to solve it?
Does anyone know where I can find an easy example of how to read an Excel or XML file and automatically populate a table on a ASP page?
I want to create an asp page that has a table on it that reads from a XML or Excel file so I can update the file and the table information changes accordingly. I know this has to be somewhat simple but I cant seem to find any exmaples. I probably am not searching the right keywords or something.
Any suggestions on where to find an example script to do this?
I have 2 dropdowns (or listboxes). 1 is for list of books called "book_title". I use a different recordType for value. Code:
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.
Can someone help me with some code examples to be able to upload an image using ASP pages and VBScript.
View Replies View RelatedI'm using ASP and HTML for a form. I'm having a major issue with users copying from MS Word or Work Perfect into my text boxes. What I want to do is top this with either html, javascript, or asp.
View Replies View RelatedI have set up a new server and now I try to move all the web ASP files, scripts to my new server. I do copy and paste all the files to my webroot directory. None of the page works, the browser simplely redirect me to the search engine page. I have about total 50 ASP scripts and files. None of them shows after I entered the address in the browser. No bug and no syntex errors.
If I created a very simple ASP page like "Hello world", it works fine. Then even the Hello world page stopped working after I copy and paste any parts of the code from my backup CD. I also heard someone mentioned about domain name hard coded program, could it possible in my case?
I'm having loads of problemsgetting my basic cdo.message script to work - does anyone havea working one I can just paste into the page? I'm getting really fed up with this one.
View Replies View RelatedI couldn't figure out how to write a function to do above tasks all at once.
For example,
Dim strMessage
strMessage = " Hello, <Quote> It is rainning outside </Quote>. I'm in a bad mood.
The function should search the <Quote> and </Quote>, copy all the text within the quotes and store them to another variable, at last change its font size and style.
So the search result will be: It is rainning outside Font size changed to 12 and font typle black arial.
i want to know that is it possible to copy from a word document and paste it on to a textarea on a asp page.
when i do it normally bullets are not paste as it is it is changed into different symbol( inverted ?)
I have set up a new server and now I try to move all the web ASP files, scripts to my new server.
I do copy and paste all the files to my webroot directory. None of the page works, the browser simplely redirect me to the search engine page. I have about total 50 ASP scripts and files. None of them shows after I entered the address in the browser. No bug and no syntex errors.
If I created a very simple ASP page like "Hello world", it works fine. Then even the Hello world page stopped working after I copy and paste any parts of the code from my backup CD.
I also heard someone mentioned about domain name hard coded program, could it possible in my case?
If I copy & paste from a RTF document into a field, the javascript validation and field length are bypassed and cause the form to fail.
View Replies View RelatedI have a dynamically-generated asp web page which uses Office Web Components
to display an Excel bar chart of the user-selected data. The page works
fine, but the users would like to copy-n-paste the displayed bar chart from
the web page and insert it into an email (MS Outlook) or report (MS Word or
MS PowerPoint).
Is there any way of supporting this copy/paste functionality? When you
right-click on the chart in the displayed web page (viewed with MSIE6), you
are only given the pop-up button [About...] which displays the "About
Microsoft Office Web Components" splash window ("Version 9.0.0.8028 SP-3"
etc.)
Currently, the only work-around is to "Print-Screen", trim using Paint, and
then paste into the destination. This is too tedious and beyond the
capabilities of some of the users.
I want to create an ASP page, which can copy the real PDF files into
the clipboard and then the user can paste it in Outlook message as
attachments(it's like inserting attachments)
My idea is: When user checked the checkboxes for the requested PDF
files from ASP page and press the "Add To Clipboard" button, all
requested PDF files will be copied into clipboard. Then, the user open
MS outlook message and right click -> Paste all PDF files as
attachments.
But, my code is just can copy the filepaths into clipboard not the
REAL PDF FILES. How can I copy the REAL PDF FILES? Code:
I have aproblem to transfer a data from table x to table y based on id. Its mean when 2 table have same id all data table x must move to table y. I don't know which command need to use is it insert into or update?
<%
Dim conn
Dim rs
Dim MYSQL,MYSQL2
Set conn = Server.CreateObject("ADODB.Connection")
Set rs = Server.CreateObject("ADODB.Recordset")
Set cmd = Server.CreateObject("ADODB.Recordset")
conn.ConnectionString = "DSN=prmm;UID=administrator;pwd=sa"
conn.Open
startdate=request("tarikh1")
enddate=request("tarikh2")
MYSQL = "SELECT * FROM table_x where paymentdate between '" & tarikh1 & "' and '" & tarikh2 & "'"
rs.open MYSQL,conn ....
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 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 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.
I am trying to display the content of a Table called
'Order Detail' directly from the database (e.g., Northwind.mdb). I have the following commands:
Set tableSet = Server.CreateObject("ADODB.Recordset")
tableSet.Open table_name, DB_name, adOpenForwardOnly, _
adLockOptimistic, adCmdTable
where, table_name = ''Order Detail" Or
table_name = 'Order Detail' Or different variations.
I always get error on the second command with the following message:
Syntax error in query. Incomplete query clause
which I believe because of space in the Table Name. How can I resolve this issue? (working with file or table name with space)?
Can one form be set up to populate two or three tables? If so, how?
View Replies View Related