I have been given the task to create a search page to search on of the tables in the sql database. I have been asked that the user should be able to search any field(which I
have done) but he should also be able to customise the form to display or hide any feilds in the results.
My table has about 20 feilds and different users wanting to you the search page will like to see different set of fields.
I get all excited to to pump some data into these PDFs that some loan-sharks want to use on their intranet, and then I find that the Adobe Acrobat SDK doesn't support .NET (which they said they did); however, one may access a little "tip" from Adobe if one joins their dev community for the low annual fee of $195.00. Has anyone taken advantage of these features of Acrobad Pro 6.0 in .NET? I'm going to try, but some "tips".
View Replies View Related I am using a repeated field to bring in to my page repeated records, and I have been able to retrieve values that are entered into text boxes that are associated with these repeated fields. I would like to post these values into a database, but I'm not sure how to set up my table as I know that each employee's values as well as number of fields will be different.
I thought about setting up two tables. One that houses the dynamic question and the other to house the answers, but I'm not sure if that will work. I could really use help as to the syntax to write a loop statement that will insert my returned variables and create the field names dynamically into my database table. I believe this is what i need to do.
I'm looking for a few methods for displaying contents of a recordSet, displaying the recordset in a table format, allowing the user to update the information they want to modify, then saving that info back to the database. I know of a couple of ways of doing this:
Create an html table dynamically from the recordset, assign the values html ids, write the info back to the recordset on form post and update the db. OK, that's the only way I know.
I want to build a site that I can manipulate from Access and have the changes show up on the ASP page.
For Example:
I have Table A that has four fields in it.
ID
Name
Date
Phone
I change the table to include another field, say SSN.
Is there a way that I can build my ASP page to do a loop everytime it opens to looke for new fields and display that as another part of the page?
I understand loops and If statements I just need to know the right code for listing the fields of the recordsource.
I have created an email form in which all fields must be completed. If all the fields are not completed "submit" causes a refresh using response.redirect, Problem is allthe fields that were previously filled in are empty.How do I keep the values of the fields on refresh?
View Replies View Relatedi have two tables:
Employee
TokenID (pk)
...
..
Rating
TokenID (pfk)
...
...
I want to display all fields from both tables ..
but TokenID should come once as it a foreign key in Rating table..
what would be the resultant query
I am using this script to submit my form fields into the body of my email:
***********************************************
Dim strBody
dim ix, formElementName, formElementValue
strBody = "Results of form submitted at " & Now() & vbCrLf & CrLf
For ix = 1 to Request.Form.Count
formElementName = Request.Form.Key(ix)
formElementValue = Request.Form.Item(ix)
strBody = strBody & (formElementName & ": " & formElementValue & vbCrLf)
Next
***********************************************
I'm completely new to vbscript and have been searching all over the net for an example of this script being used with mutliple fields with absolutely no luck.
The closest I've come to getting something back from this thing is when I tested the script with these elements:
FormElementName = Request.Form.Key("Name")
formElementValue = Request.Form.Item("Name")
formElementName = Request.Form.Key("Telephone")
formElementValue = Request.Form.Item("Telephone")
formElementName = Request.Form.Key("Email")
formElementValue = Request.Form.Item("Email")
Which produced this result:
Email: Email
Email: Email
Email: Email
Its seems the answer to my problem lies in defining the 'Key' and possibly the 'Item' parameters but I haven't been able to find any documentation on these terms. Can someone out there please save me from what probably is a very simple solution?
what is the easiest way to display Yes/No, True/Falst, On/Off MS Access fields as check marks on an ASP page? it would be either checked or unchecked.
View Replies View RelatedI have the following piece of code:If RS.EOF or RS.BOF Then
Session("Authenticated") = False
Response.Write "Sorry, your userid or password did not match"
Response.Write "<BR>"
Response.Write " or you have not registerd yet, please register"
Response.Write <a href="default.asp">Clik here
Response.End
Here, I need to build the line (Response.Write <a href="default.asp">Clik
here)
dynamically, so that the html output from asp page
gives us <a href="default.asp">Clik here
i have a long recordset that i want to page through. can sql pass back say, 5 records from 20 to 25 out of 1000?
i can then pass 2 variables between the pages to dynamically generate the sql and thus page through the results. can someone post up a simple example of this if its possible?
With ASP is it possible to dynamically change the <title> tag depending on what record I am viewing? I know that you can do this isn ASP.net and PHP but was wandering if its possible in ASP too
View Replies View RelatedI am currently struggling with dynamically naming a zip file. Basically I want someone on my ASP site to be able to choose to download a zip file and the zip file to be renamed before it is sent to them with their login name. Does anyone know how I might accomplish this. Code:
View Replies View Relatedi have a form with two pull-down menus. when the user chooses a value from one, I need to go to the db and execute a query, and then populate the 2nd pull down menu with the retrieved values.how would I go about this? where do I add the listener function that will catch the selection event, and what should go in it?
View Replies View RelatedDoes anyone know if there are any IIS components out there that run on
IIS 5.0 that will convert LaTeX to PDF? I have written a script in ASP
that produces the LaTeX document, but am unsure of how to go about
converting it to PDF and delivering it to the client.
If you don't know of one, do you have any idea of how I might implement
such a transform? I would have to use a WshShell to run pdflatex on
the source twice before I could deliver the PDF to the user. However,
pdflatex outputs a PDF, so I would have to redirect the client to the
PDF, and then somehow come along later and clean it up. I'm not sure
if this would be the optimal process to take.
I have a form where there are 2 dropdowns. Based upon what you select in the 1st dropdown, that selection populates the 2nd dropdown. I want to change it so that if you select 'Loan Officer' in the first drop down, the 2nd dropdown turns in to a textbox, rather than the huge dropdown it becomes now
View Replies View Relatedthis form I need to create, I have very little experience in ASP. I will basically need to have a form that collects hours for a specific Week End Date.Also a running total for hours.
Dropdown with week end dates
Dropdown of Task, Mon, Tue, Wed, Thurs, Fri, Sat, Sun
Default 5 rows
Add Row Submit
Since I will need to dynamically add a row of data, I am not sure how to submit. What would you do in this scenario? Im so new to this and of course this is due ASAP.
I have an asp page in which if i click on add row i call a javascript function and create a new table row.This works well if i do not have to retrieve any dynamic data from my database. ie if i just have to insert for input type ="text" then no problem but when i have to do the same thing for a input type ="select" i have no idea what to do for the select has to retrieve records from the databse to allo the user to choose. How can i do this ?
my javascript function
function addrows()
{
var cellRight = row.insertCell(1);
var el = document.createElement('input');
el.setAttribute('type', 'text');
el.setAttribute('name', 'comment' + iteration);
cellRight.appendChild(el);
}
how can i adjust this to allow for select tag ?
Using preferably Asp or an Asp component, but maybe .NET, here is what I need to do:
A user enters a hex value (Or rgb if need be), which then colors a pixel high, n pixels wide gif and saves it to a folder in the sites directory.
I have a form that is created dynamically from a recordset, this creates a line for each record together with 2 checkboxes, Yes & No so the source output would be something like this:
<p>Please indicate whether you still use each piece of software detailed below:</p>
<form name="apps" method="POST" action="MyAction.asp">
<table width="600" border="1" cellspacing="0" cellpadding="5">
<tr bgcolor="#9999FF">
<td><font color="#FFFFFF"><strong> Software</strong></font></td>
<td><font color="#FFFFFF"><strong>Required?</strong></font></td>
</tr>
<tr>
<td>Adobe Photoshop 7.0 7.0</td>
<td><input type="checkbox" name="Yes" value="Adobe Photoshop 7.0 7.0">
Yes
<input type="checkbox" name="No" value="Adobe Photoshop 7.0 7.0">
No </td>
</tr>
<tr>
<td>Citrix ICA Client</td>
<td><input type="checkbox" name="Yes" value="Citrix ICA Client">
Yes
<input type="checkbox" name="No" value="Citrix ICA Client">
No </td>
</tr>
<tr>
<td>Macromedia Dreamweaver MX 6.0</td>
<td><input type="checkbox" name="Yes" value="Macromedia Dreamweaver MX
6.0">
Yes
<input type="checkbox" name="No" value="Macromedia Dreamweaver MX
6.0">
No </td>
</tr>
</table>
<p>
<input type="submit" name="Submit" value="Submit">
</form>
And so on......
I want to ensure that either Yes or No has been checked for each line before the form can be submitted, can this be done in asp? The amount of lines in the form will vary.
i want to download a folder (folder contains .gif files) from a server. which is the best way to download,
1.zip a folder ?
2. or can we download a folder?
i am trying to zip a folder but without using any component. can any one help me regarding this. when i search in google i got code using only component. I want code using pure asp.
I am trying to create a blank table based on an existing table. I have tried using CREATE TABLE but unfortunately it doesn't appear to be flexible enough in that it didn't allow me to set some of the field properties such as input mask on a date field. Now if I can dynamically copy a table that will solve my problem.
View Replies View RelatedI am trying to figure out how I could name a local variable dynamically.For example:
Dim Grade & SSP_Get_Stud_Grades("GradeYear")
Its kind of how you can name form fields dynamically
for example:
<input type="textbox" size="2" name="<%=GradeCtr & SSP_Get_Courses("CourseID")%>" value="<%=GradeHolder%>">
What I am basically trying to do is put each grade from a query into their own variable which has a name that basically tells me where to display the grade on the page.
A Form has a select list which lists all the column names of a SQL
Server database table. Users will select one or more than one column
from this select list & after submitting the Form, the records of only
those columns that he had selected in the previous page will be
displayed to him. This is the Form code:
have a number of text box rows generated dynamically with the same name. This gets posted to the same page as a comma delimted string.
The Problem: If a user enters a comma the string gets disjointed.
Need to parse(remove commas)the dynamic text box values generated on client side.
i need to build a booking system which relies on a calender. basically i have a db of clinics thar offer allotted times for appointments on certain dates. eg: a clinic may offer five 20 minutes slots 2 days a week.
so i need to get the data out of the db and display that in a calender form which the user can then select the time/date convenient to them. my question is (apart from how do i build this!?!?!?!) does anyone know a good calender that would fit my purpose? Code:
There are two files here.. TEST_CHART_RUN.HTM calls the second file. Please copy and paste these files as needed to htm and asp files.
View Replies View RelatedI have an array with the values: 1, 4, 7, 8, 2
I want to loop through the array and dynamically name a variable to append the array elemnt to the variable name something like this:
i = 0
while (myArray.length){
var myVar + myArray[i] = "my variable name is called:" + myVar + myArray[i]
i++
}
but i cant name the variable dynamically. Do I have to do something like: String(var "myVar" + myArray[i]) or something?
I got this .aspx page with no access to the source code.(apparently it was lost)
anyways. I have this form with a datagrid that access values from a database.
<TD align="left" width="293"><asp:dropdownlist id="DropDownList16" runat="server" AutoPostBack="True"></asp:dropdownlist></TD>
<TD align="middle" width="127">$<asp:label id="Label32" runat="server">0</asp:label></TD>
If you look at the code above, asp:dropdownlist is a string, but I'm not sure if asp:label is a numeric. Since I don't have the source code, how can I change the numeric value that gets to the asp:label within the aspx page.
lets say i get a number 20, and I want to add 15 to it, how can this be done.
There is this thing which to me looks possible, but when I searched over
the net I couldnt find anything. Any ideas about this please do let m
eknow.
I want to create a page where I can upload an image using any upload
function and then display it.
Now after diplaying it I want to select the hotspots for it and create
an image map.The coordinates of image map are stored in a database.
Basically I want that to create image maps and hotspots I dont use any
offline software, get it done Online using ASP or any other thing that
you may suggest. Code:
Can I include asp files dynamically? If the result is 1 then include file 1.asp, if the result is 2 then include file 2.asp, Can this be done?
View Replies View RelatedI am tryimg to create a RadioButtonList dynamically. My code below gives an "Index was out of range" error. Where am I going wrong?
Sub CreateRadioButtons(ByVal dr)
' Instantiate RadioButtonList
Dim DynamicRadioButtonList As New RadioButtonList
Dim t As Integer
t = 0
Do While dr.Read()
DynamicRadioButtonList.Items(t).Text = dr("PRO_en")
t = t + 1
Loop
'Add radio button
PlaceHolderGroup.Controls.Add(DynamicRadioButtonLi st)
End Sub
Creating an rss.xml file dynamically via ASP/ADO/DB, but find errors in the
file.
Don't think it's an ASP prob to be honest. Think its more to do with the
fact that the ampersands are accepted in the file. Do I take it that you
have to 'escape' all non alphanumeric chars to produce a valid file?
I thought xml files were supposed to eradicate the usual invalid char
problems that tab-delimited and csvs used to have