Tracking Forums, Newsgroups, Maling Lists
Home Scripts Tutorials Tracker Forums
 
  HOME    TRACKER    ASP




Inserting Multiple Names


if its possible in dreamweaver ultradev4 to create a pop-up box where i can select multiple names which can then be added to another field on a sepearte page. This popup page needs to be dynamic as new users are added to the database daily.

Basically its the way that hotmail handles the address book. The user clicks a button to view the address book, they select the people they want to send it to, then click ok & all of those names appear in the 'to' box.




View Complete Forum Thread with Replies

See Related Forum Messages: Follow the Links Below to View Complete Thread
Inserting Names With Apostrophes
I did a search about inserting names that have apostrophe, and found something about escape apostrophe? how to do that? When the user tries to insert a name with an apostrophe it blows up. Also the delete page I have doesn't like names with apostrophes in the where clause.

Multiple File Names
I have an ASP.NET Web application where I want users to specify browse/select multiple files in multiple folders on their local workstations.Upon submitting the form,I want to have server-side code to manipulate the files.This is something like writing an email with attachments via a web form

What is the best way to accomplish this?Are there some examples of how to browse/select files and pass them to the server-side code

Inserting Multiple Row Through Sql
How do you insert multiple row in 1 sql statment?

Inserting Multiple Records
Im having a hared time with this, im trying to update multiple records in a database from a form.

The form display all records from a search query and then the user selects whether to post the record of put the record on hold (two fields in the database).

Now everywhere I have looked I only see examples which update the records by using counts but I could end up with any number of records. I thought that using a loop would be an idea to get passed this.

Inserting Multiple Records
Does anyone know how to upload or insert multiple records into a MS Database. I've been trying to figure this out all day with little success. It seems that their should be a way to upload a txt file or csv file and have all the records go into the dbase.

Inserting Into Multiple Rows
if i have an online invoice and i want to insert all the items of the form into different rows of a table.
is it possible and can get the code ?

Inserting Multiple Records
i've created a page that displays a list of records with a checkbox next to each.

I'd like to give my users the option of selecting multiple checkboxes then clicking submit which will insert a new record for each of the checked option.

for example: Code:

Uploading & Inserting Multiple Images
How can I upload & insert 2 images to the server using asp, I used this code for one single image....I need to know for 2 images in order to insert them in database

The following is the code :

Set Upload = Server.CreateObject("Persits.Upload")
Upload.IgnoreNoPost = True
Upload.LogonUser "","maf","fam@dmin"
Upload.Save server.mappath("/uaeagricent/AgriNews/Newsimg/")

session("path")=""
For Each File in Upload.Files
session("path")=file.path
Next....

Inserting Into Multiple Tables From ASP Page.
I've been building an ASP app that sits on top of a relational database (MS Access). The problem is that the data from some web forms need to be stored in different tables. Currently I am using multiple SQL Insert statements.

The problem with this approach is that it is possible that several inserts would succeed and then one would fail. This would ruin my database. Is there some way to synchronize the Insert commands or to "flush" the commands at the same time? I need the Insert statements to either all succeed or all fail.

Multiple Radio Buttons/textboxes – Inserting Into The SQL DB?
I’ve a few radio buttons; few of them have input textboxes and dropdown list.
I use Select case to insert values (depend on which radio button that you've selected) into the sql db but it doesn’t work. Then I use if, elseif and else…the value of radio still doesn’t insert into the DB. In this case how can we insert the value(s) into the DB? Code:

Get Tables Names
Does anyone have some sample code on how to get all tables names in a MS Access database?

Names Of Scripts
I need the names of some either ASP or PHP programs that will work like a video rental store. I know there are some out there, but i cant seem to remember the name of them. I would prefer something that is free.

ASP Variable Names
Does any one know how many characters possible in a variable name in ASP?
Is it only 15 characters long or could it be more?
i.e. could the variable name be ThisIsTheFirstName
I do not name my variables like this but I would like to know the max length possible.

Cdonts Names
I have a web application which saves files to a server and emails the file as an attachment. I generate a unique name for each file by concatenating a unique numeric string so the file name is unique and cannot be accidentally be overwritten. I also store the original name of the file. Is there any way to rename the attachment when I send it so it doesn't have the unique name but rather the orignal one.

Column Names?
im reading from multiple databases, and one restraint is that i must know the amount of columns and the names of the columns before i can display info from the database.my question: can i somehow GRAB or READ this information from each database and then just adapt my Display accordingly

Using Arrays With Names
Is it possible with ASP to use arrays with names (e.g user("username") = "ble") instead of numbers (e.g user(1) = "ble")?(I do know of the dictionary object, but is it wise to use that 7 times or more a page?

SQL And Table Names
ive got a small problem, i dont know if this is possible but its bound to be. What im trying to do is request a cookie which contains a database table name and put that inside an sql query...sort of like this

id = request.cookies("tablename")
mySQL = "SELECT * FROM &'id'&"

i know that doesnt work, ive tried every other combination .

Table Names
I am planning my next move on my current website and am looking at doing the following. I am adding a feature where as a database can be viewed on the web page as this has been requested for me to do.

I am pretty sure i can do this without a problem except for getting all of the table names. Is there an SQLQ command where you can say

SELECT (ALL TABLE NAMES) FROM DATABASE.

Antoher way to look at it is to have a seperate table in each of the databases to hold all of the table names.

Get File Names
a script that will automatically pull the names and custom preview icons of image files from a folder and display them on a page? is this possible? i need to use this script on a win 2000 server.

Path Names
I have two temporary variables that are equal to folder paths. The first temporary variable could equal one folder name or multiple folder names depending upon an if statement so "" & fldr1 & "" & folder.name & "" will not work.

Is it possible to combine both into a third temporary variable? Example:

TempPath1 = "" & fldr1 & ""

TempPath2 = "" & folder.name & ""

FullTempPath = TempPath1 & TempPath2

FullPath = fso.GetFolder(Server.MapPath(FullTempPath))

Get List Of Names
We have a script the will grab names from a form and display them on the next page but will only get a max of 60 to 80 names depending on the total number of characters of each name.

Can anyone guide us on how to create a script, where if a user copies and pastes 5000 names or email addresses into a form and clicks submit, we can then grab each name and display individually on the next page?

First Names/Nicknames
Does anyone know of a script or library that provides a way to match first names with common nicknames or shortened forms?

I'm developing criteria to determine whether two database entries represent the same person, and I definitely want people named 'Bill' and 'William' to score as having the same first name, for example.

PostField And Variable Names
I am new to ASP and I cannot figure out how to pass variable content in ASP. How to pass the variable sClientNo in the following redirect.

Response.Redirect("AccessDenied.asp?ClientNo=sClientNo")

Spaces In Column Names
I have a db auto uploaded to me everyday. I am displaying information from the db, but some of the columns contain spaces. When I use a space in a select statement it obviously does not work. Is there some special syntax I need to allow for a column name that contains a space?

Input Field Names
I have built input fields inside a while not.eof loop
and the name is built from using <%="name"&i%> and the value is a product_id
from the database.the i is then incremented in the loop, resulting in <input name="name1, <input name="name2
and so on. this works no probs, however i haven't got a clue on how to collect this dynaimcally named
input field when it arrives at the form action address page.
I was thinking some kind of for loop but am not sure, and again am not sure where to put the <%="name"&i%> bit
to count or grab the input fields info.

i.e newname= REquest.Form(<%="name"&i%>)

Database Field Names
I have a "csv file" as a database.

The 1st row contains the field names:

Orion.Accounts.AccountName,Orion.Accounts.Address1

the code I use normally works:
<%=rs("Orion.Accounts.AccountName")%>

Although in this case is doesn't because the fieldnames contain full stops.

how to modify this line:
<%=rs("Orion.Accounts.AccountName")%>

Getting Form Element Names
I have a dynamic form sending information via name=value pairs.I know I can read the value of each element in the sending form by using the following....
for i = 1 to request.form.count
response.write "<p>" & request.form(i)
next

but since it's a dynamic entry page (it's built based on number of fields in a database), I need to know the name of each element also.not just the value.Is there a good way to get the "name" portion of the element on the form without having to parse through the request.form string?

Collections In ASP: Names Vs. Numbers
I am using the Folder.Files collection to display all the images in a given
directory. The following shows the code I use to create and use this
collection:

Set myfilesys=Server.CreateObject("Scripting.FileSystemObject")
Set mydirectory=myfilesys.GetFolder(Server.MapPath("./emoticons"))

When I use a specific file name to access a file, my code works fine:

<img src=" & Chr(34) & mydirectory.Name & "/" &
mydirectory.Files("blinkgirl.gif").Name & Chr(34) & ">

However, I want to iterate through all the files in the Folder USING NUMBERS
(I already know how to do it using a For Each statement). But whenever I try
to do this, I receive an error:

<img src=" & Chr(34) & mydirectory.Name & "/" & mydirectory.Files(5).Name
& Chr(34) & ">

Other collections, such as the Request.Form collection allow you to access
the collection using either text or numbers, and all books that I have read
have said that this is true for all collections. Is the Folder.Files
collection an exception to this? Is there something else I need to do?

Linking Names To URLs
I have a dynamic table that displays names of companies. Some companies have URLs and some don't. I would like for those companies with URLs to open a new browser and show their website, for those with no URL just to open nothing. So far I have this, however doesn't work.

SQL Keywords And Field Names
Does anyone have a definitive list of keywords to avoid or prohibit as field names for the tables for an ASP driven program that communicates with a SQL database?

I have a website that allows customers to define tables online and I keep hitting the field names I need to prohibit - "Function" is the latest one. I'd like to just compare the users field names with a list and end this problem for good! Also any VBScript words too?

Manage Table Names
I would like to be able to generate table reports listing all the TABLE NAMES, FIELDS and their datatypes in a neatly formatted table.

Additionally I am building up a frightening amount of queries.I would also like to cycle through this and neatly associate notes with them to remind me of their specific purpose.The naming of the query can only go so far.

I find that upon returning to my asp and access application after a month or two I struggle to contextualize where to begin query additions and table alterations
and hope a catalog method will make me more effective and save time.


Changing Tables Names
I wanted to know if it is possible to change MSAccess Tables Names through ADO in ASP. is it?

Display All File Names
Is there a way that you can display all of the names of the files that are in a specific folder that I have set with the website? So for instance is there a way for .asp to show all of the files that are in the c:userdocuments and settings. So when someone clicks that link, it will let them open up the file.

GetRows With Field Names
When using RS.getRows how do I go about getting the field names from the database as well?

How To Use Two Submit Buttons With No Names
i can select multiple users and approve them when there is single submit button titled approve but with no name because the multiple selection technique works only if no name is given to a submit button. i also want another submit button for declining users.

my process works fine if there is only one submit button.
but how to add another submit button and make it work without referring them with name attribute. Code:

Displaying Certain Field Names Only...
I am trying to display only certain columns from a table and this is a code that I am using but it is not diplaying anything, can anyone tell me where my code is wrong

<%FOR EACH field IN rstSite1.FIELDS
if field.name ="EmpName" then
RESPONSE.WRITE("<TH ALIGN='LEFT' BGCOLOR='#B0C4DE'>"& FIELD.NAME & "</TH>")
end if

NEXT%>

Get Data From A Form With Different Field Names
I am designing a shopping site, in the picture the #1 section is a check box behind product name that customer can select that product to buy in #2 section the customer can set quantity of the selected product ok now codes this is the code which I have used to pull out produts and categoris from database and show them on the page Code:

Radio Buttons Group Names
I am working in ASP.NET and I do have groupname of TrainReport for all of my radiobuttons. I have found lots of documentation of how to put groupnames in radiobuttons. What I have not found is how programmically I can use the radiobutton groupname in the code to distiguish between the radiobuttons.

In VB 6.0 the group of radiobuttons would have the same name and would be refered to in an index by the order of the buttons. TrainReport(0), TrainReport(1), TrainReport(2), etc. I could use case statement on the index.

Case 0 would be if TrainReport(0) was selected and I would have code I want to do if this was selected, Case 1 would be if TrainReport(1) was selected and I would have code I want to do if this was selected, etc.

I have not found in documentation in Visual Studio, google searches, etc. a useful purpose of radiobutton group names.

Creating 'vanity' Domain Names On The Fly
I'm working on something similar to blogger.com. Users sign up and they get
their own webpage, with a domain name of 'username.blogger.com'.

Since blogger.com is doing it on the fly (as you sign up), I'm sure
they are doing it programmatically. Anyone has any clue on how they do
that?

Turning Strings Into Variable Names
if there is a quick way of converting a string into an actual variable.The reason I ask this is to save me having to type each variable name out when trying to request the values from a form.

Using Eval To Set Dynamic Object Names
I've ran into a little trouble with Eval, hoping someone can point it out to me. This code works :

var_ktml = "textarea2"
Set ktml_textarea2 = new ktml4
Eval("ktml_" & var_ktml).Init var_ktml

This code doesn't :

var_ktml = "textarea2"
Set Eval("ktml_" & var_ktml) = new ktml4
Eval("ktml_" & var_ktml).Init var_ktml

Can anyone point out the error of my ways ?

Reading MSAccess Table Names
Is there any way of using ASP to read the names of all the tables within my database?

Using Form Field Names In If Statements
I tried posting this a minute ago but timed out, so sorry if this is posted twice.
I want to make an IF statement in ASP using VBscript that will run if a checkbox in a form is checked (and won't otherwise). How do i refer to the form field (checkbox) in the IF statement to do this?

Convert State Names To 2 Digits
I currently am using a script which submits full state names to a payment processor. However, the payment processor only accepts 2 digit state names. Does anyone have a premade code for asp that converts state names into 2 digit ones.

example:

If statename = "New York" Then
statename = "NY"
End If

for each state.

SQL Server - Update/Insert Multiple Cols Into Multiple Tables
Just as the title says I am trying to do something impossible with a single SQL statement. I am doing an ASP webpage for internal use at the company I work for.

I want to know if there is a way to insert/update data into multiple tables in 1 SQL statement.

If it requires functions | views or anything else that is fine but I don't want to have 3-4 different SQL statements to update 2-3 different columns in different tables.

Searching Multiple Memo Fields In Multiple Tables In Access
I have a search option on my website, which should perform a search on 4 fields, as follows:

tblNews
headline
content

tblDatabank
filename
description

It only needs to return matches which are an exact match of their search criteria. For instance, searching for "I am here" would return a record which contained "I am here", but not just "I" or "I am" etc.

I need to return all these records as part of one recordset preferably, as I want to be able to order them etc., though I imagine you may suggest I use an array somehow to merge two recordets etc., then reorder them?

Creating Dynamic Variable Names In A Loop
I'm having a brain fart at the moment. Can someone tell me how to dynamically create variable names based on a loop counter?

for i = 1 to Num_Cart_Items
Item_Name & i = Request.Form("item_name" & i)
Item_Number & i = Request.Form("item_number" & i)
next
Desired result:

Item_Name1 = Test Product
Item_Number1 = 1234
Item_Name2 = Test Product 2
Item_Number2 = 2345

The problem is with the Item_Name & i..I used to know how to do this, but I can't remember or find any code that I did this with.

Replace Rude Names In String With Anonymous
I'm going to make a database of rude words, that i do not want users to name themselves when they use my scoreboard. I need my asp to scan their string and if a word from the database appears replace the entire string with anonymous.

I have some code which was designed to astrisk out all but the first and last letter of any appearing rude word

eg: d**n this b****y game
or godd**nit

i have changed this to just replace each word to anonymous, but cant get it to the stage above, can any one help? My code so far is below. Code:

ASP Script Or File To Check Domain Names
iwant an online domain name checking on my website, I tried few scripts but didnt work well. If some one can give me a script through which I can check online domain names .


Copyright © 2005-08 www.BigResource.com, All rights reserved