Knowing Column Names
I'm working in ASP VBScript, and I'm trying to transform an SQL row into a formatted line of text. My question is, is there a way to bounce through columns without knowing their names (like an array).
The answer to the obvious is yes, I do know all the names of the columns, but I'm trying to minimize future maitenance and this should be a fairly simple process. Basically I need to get the name of each column and it's value in a specific row, and I need to do all of this in ASP.
View Replies
ADVERTISEMENT
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
View Replies
View Related
Is it possible to get a db's column names not the data inside the columns just the columns names.
View Replies
View Related
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?
View Replies
View Related
I have 2 joined tables with several duplicate column names and I am very confused as to how to "rename" them and then do my query.
In the generated Excel report I need to reference both at different times. Here is the Query: Code:
View Replies
View Related
I'm developing an intranet site that will require knowing who is accessing the site. Since all of my users are using a WIndows domain, I figured I could cut the necessity to log into the intanet site if I could identify each user based on who is logged into the workstation being used to access it. So I figured I would need some Microsoft-specific tech to get this done.
Is something like this even possible? I figure ASP .NET would be my best hope, but seeing that I've never programmed for a Microsoft environment, I would need some coaching. Here's how I thought this could be accomplished (I may need some help filling in the details):determine the IP of the machine accessing the sitedetermine which machine on the network currently has that IPask Active Directory who is currently logged into that machineI don't know that this is possible in this manner, though. Anyone accomplish something like this before? I would think so as it seems like something a lot of developers would want for web applications.
View Replies
View Related
I have a requirement to record in a database when a file is finished
downloading to the end-user. Currently when a user clicks a download icon
for a file it directs to an ASP page that records the "hit" into a database,
then I use a response.redirect "filename.exe" to point the user to the
download.
What I'm missing is knowing when the download is complete so I
can update the database to show the file successfully completed its
download. Is there a way to do this with ASP? A way to do this with an
aftermarket component?
View Replies
View Related
I want to be able to connect to the database (the name is known) and then have it report back the tables in the database and the columns available in the tables. Is there a way to do this?
View Replies
View Related
I want MS Access 2000 database column of table 1 = column of table 2. This is what I was doing: Code:
View Replies
View Related
Does anyone have some sample code on how to get all tables names in a MS Access database?
View Replies
View Related
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.
View Replies
View Related
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.
View Replies
View Related
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.
View Replies
View Related
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?
View Replies
View Related
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 .
View Replies
View Related
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.
View Replies
View Related
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.
View Replies
View Related
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))
View Replies
View Related
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?
View Replies
View Related
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.
View Replies
View Related
in my drop down dont want to show country names like United States and Canada but its still showing Code:
nusa="United States"
ncanada="Canada"
Set rs = Server.CreateObject("adodb.RecordSet")
strcountry="SELECT * from tblCountries where CountryName Not In ('"& nusa & "," & ncanada & "')"
rs.Open strcountry,cardconn, 2, 2
is the syntax ok
View Replies
View Related
i want to make a drop down menu with the names of the tables in the mdb. how do i get this right? do i use a sql statement? i cannot find a sql statement with the command for this.
View Replies
View Related
I 'd like to print out all posted parameter names and values. I'm able to print all the posted request values, but not the parameter names.
View Replies
View Related
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")
View Replies
View Related
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%>)
View Replies
View Related
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")%>
View Replies
View Related
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?
View Replies
View Related
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?
View Replies
View Related
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.
View Replies
View Related
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?
View Replies
View Related
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.
View Replies
View Related
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
View Replies
View Related
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.
View Replies
View Related