I wouldn't swear to it but I think that JavaScript 1.1 back in the 4.0 days
fields of the same name in a form created a collection under the form that
could be accessed like so:
for (i=0; i<= document.formname.subtotal.length; i++)
{
runningtotal += document.formname.subtotal[i].value
I have a project where employees will choose items from a company store.
Each product on the page will have a description, price per item and
subtotal. This is presented as a Web form, dynamically generated out of a
product database. At the bottom of the page is a grand total and submit
button. Wh
Here's the message I got about it, although I haven't received one of these
messages yet.
A new Visual Basic Script (VBS) virus named Mawanella is in the wild
on the internet.This virus is propagated through email including
Microsoft Outlook. A sample of the email the worm se
http:[EMAIL PROTECTED]
Keith Purtell, Web/Network Administrator
VantageMed Operations (Kansas City)
CONFIDENTIALITY NOTICE: This email message, including any attachments, is
for the sole use of the intended recipient(s) and may contain confidential
and privileged information. Any unauthorized re
Thanks Randy!!!
This worked like a charm.
I'm not sure this gets said enough but this list is a
very good source of information.
Chris
--- "Ellis, Randy" <[EMAIL PROTECTED]> wrote:
> Here is a working solution I just created. If the
> code is not clear, email
> me with questions at [EMAIL PROT
Cute, but not the right kind of virus. Got it sorted, thanks.
-Original Message-
From: Daryl Banttari [mailto:[EMAIL PROTECTED]]
Sent: Thursday, May 17, 2001 2:37 PM
To: [EMAIL PROTECTED]
Subject: Re: [KCFusion] SQL table listing - Access
http://www.google.com/search?q=sri+lanka+virus
http://www.google.com/search?q=sri+lanka+virus
- Original Message -
From: "Nathan T Haley" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, May 17, 2001 2:13 PM
Subject: RE: [KCFusion] SQL table listing - Access
Hey,
Does anyone know about a virus having to do with "Sri Lan
Ryan,
Depending on how often you run update stats on the SQL
database you might be able to use this.
This will loop through all databases on sysdatabases
and then get all the tables in the database and
finally list all of the columns in the order they
should be.
DECLARE @ls_db varchar(255),
Hey,
Does anyone know about a virus having to do with "Sri Lanka"?
-Original Message-
From: Ryan Block [mailto:[EMAIL PROTECTED]]
Sent: Thursday, May 17, 2001 2:13 PM
To: '[EMAIL PROTECTED]'
Subject: RE: [KCFusion] SQL table listing - Access
But I still need to be able to access those
But I still need to be able to access those columns to input data, even
though they are empty.
>>Why don't you do a count on the number of records in the table first. If
>>the recordcount = 0 don't run the CF ColumnList program.
Ryan
_
Why don't you do a count on the number of records in the table first. If
the recordcount = 0 don't run the CF ColumnList program.
__
The KCFusion.org list and website is hosted by Humankind Systems, Inc.
List Archives..
I looked at the custom tags below, but they need a fully qualified path to
the database and must have DAO installed. So I'm still looking for an Access
solution to get just the column names from a table through a cfquery. SELECT
TOP 1 * FROM table, then getting column names using the CF ColumnList
This is what I have modified from what Bryan LaPlante sent me the other day.
You'll have to modify some of this SQL statement to whatever it should be
for SQL Server. This works with Access.
Ryan Block
SELECT name
FROM msysobjects
WHERE type =1
AND name NOT LIKE 'MSys%'
Below is a list of tab
Chris,
Your SQL code to do a table lookup and extract the column names works on SQL
7 also. Thanks a lot! Any permutations to do output all the table names in
a database/datasource?
Ryan
__
The KCFusion.org list and webs
Ryan,
This works on SQL Server 2000. You can get a specific
table or set it up to look through them dynamically.
select O.name, C.name from sysobjects O
join syscolumns C ON C.id = O.id
where O.xtype = 'U'
and O.name = 'your table name here'
order by C.colorder
Good luck!
Chris
--- Ryan Hart
Look into the sp_tables and sp_columns stored procedures.
- Original Message -
From: "Ryan Hartwich" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, May 17, 2001 12:57 PM
Subject: RE: [KCFusion] SQL table listing
Bryan & Chris,
You have given us great insight into finding t
Bryan & Chris,
You have given us great insight into finding table & column names in Access.
Do you have a way in SQL Server? I tried looking at some of the sysobjects
type tables but they are pretty heavily populated with strange data.
Ryan
_
There are a couple of cfx tags in the DevEx that you can use for this if you
have access to the server to install them.
CFX_TABLE
http://devex.allaire.com/developer/gallery/info.cfm?ID=CA347124-2830-11D4-AA
9700508B94F380&method=Full
CF_TABLEFIELDS
http://devex.allaire.com/developer/gallery/info
I have another question about sql tables and columns. Besides the table
names, I also need to be able to get at the column names in an Access
database. The folowing code works, until I get a table with no data in it,
which yields a 37000 ODBC error. I've looked through Access system tables
and SQL
I am a fairly new CF developer, and have a basic question. Is there a way
to make data elements into links that are returned in a cfgrid? I've laid
out the grid and columns, and tried specifying an href in the cfcolumn tag,
but this doesn't work. I believe it is because I have two columns that
Here is a working solution I just created. If the code is not clear, email
me with questions at [EMAIL PROTECTED]
You will need to modify the code for your stored procedures and default
values.
States and Counties
// Load every county from every state
Actually, I just wrote something very like this just to see if I could. The goal in the exercise was to create dynamic lists that didn't require me to reload the page every time I needed an update. The algorithm is entirely in javascript, and works basically like this:
You have two arrays, we'll
There are several ways to go about this, easiest would be using either the
twoselectsrelated or activeselect custom tags, the drawback being that you
would have to select all of the states and all of the counties out of the
database into a specificly structured recordset to be used by the tags.
Al
23 matches
Mail list logo
