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.
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.
html
head
titleStates and Counties/title
SCRIPT LANGUAGE=JavaScript
// Load every county
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
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
9700508B94F380method=Full
CF_TABLEFIELDS
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
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 table
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
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
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
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),
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 Lanka?
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
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 PROTECTED]
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
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
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.
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
17 matches
Mail list logo