Does anyone know what version of ColdFusion is included in
Macromedia's UltraDev4.  I read some info about the software package
and that it had full ColdFusion features, but it doesn't say what
version is included.  Please, info needed soon!

Hello everyone,

I'm new to this group, to Coldfusion and Html.

I have a couple of questions to ask.

1. I am using a lot of session variables eg. "session.variable_name".
How can I force all session variables to expire before the set time-
out in the application.cfm.

2. In SQL server , there is a variable called "@Identity" which is
the identifier to select the last inserted record of your session.
Does anyone know how to retrieve this variable in Coldfusion.


Cheers,
Tony

Hi all

I am new to the forum.

Can anyone help with some tips on formatting dates and currency
values for the UK?

I seem to have awful problems with dates in particular, where months
and days keep getting switched just by passing dates around in
variables. LSdateformat() and dateformat() both produce problems.

Currency isn't TOO bad but I can't seem to use #numberformat
(variable,"£999.99")#, for example. I have to put the pound sign
outside the whole expression, where I almost always get a space
betwen it and the number. When the currency value is negative, I get
£ -38.50 whereas -£37.50 would look a lot better.

Thanks very much everyone

Regards

David Vaughan

Sorry I think I already responded to this but I don't see it
on the list so here it goes.

Try this!

<CFSET grp = (#form.adult# + #form.children#)>
<CFSET SmRmRq = grp / 4>

> -----Original Message-----
> From: Steve Doran [mailto:sandsint@...]
> Sent: Tuesday, January 16, 2001 6:03 PM
> To: coldfusion-howto@egroups.com
> Subject: [coldfusion-howto] setting a variable
>
>
> I am setting a variable that depends on the value of another variable.
>
> I need a variable that will give me a total and not a string
> expression.
>
> This is the variable I am working with.
>
> <CFSET grp = (#form.adult# + #form.children#)>
> Assuming the number of adults is 3 and the number of children is 1.
>
> When I use this in a CFIF statement,instead of giving me the total as
> a value it give me the string 3 + 1
>
> when I do an output of the variable grp it shows the total as 4, but
> in an if statement is shows a string.  Is there a cftag or procedure
> which will total this for use in a cfif statement.
>
> Sorry for the confusion.
>
> Thanks in advance for any assistance,
>
> Steve D.
> Axhind :)
>
>
> Post message: coldfusion-howto@egroups.com
> Subscribe:  coldfusion-howto-subscribe@egroups.com
> Unsubscribe:  coldfusion-howto-unsubscribe@egroups.com
> List owner:  coldfusion-howto-owner@egroups.com
> Group page: http://www.egroups.com/group/coldfusion-howto
>
>
>

What if you just divide by 4. Would that work?!!

> -----Original Message-----
> From: Steve Doran [mailto:sandsint@...]
> Sent: Monday, January 15, 2001 9:34 PM
> To: coldfusion-howto@egroups.com
> Subject: [coldfusion-howto] setting a variable
>
>
> I am trying to set a variable that will change depending on the
> number
> of people in the party.  Below is the code i am working with.  I have
> tried "parentheses", "and", "or" and it will still not work.  Does
> anyone
> have any idea what i am doing wrong.  This looks real simple not to
> work.
>
> <CFSET Grp=(#form.adult# + #children#)>
>
> <CFSET SmRmRq="0">
>
> <CFIF Grp LTE "4">
> <CFSET SmRmRq="1">
> <CFELSEIF Grp GTE "5" LTE "8">
> <CFSET SmRmRq="2">
> <CFELSEIF Grp GTE "9" LTE "12">
> <CFSET SmRmRq="3">
> <CFELSEIF Grp GTE "13" LTE "16">
> <CFSET SmRmRq="4">
> <CFELSEIF Grp GTE "17" LTE "20">
> <CFSET SmRmRq="5">
> <CFELSEIF Grp GTE "21" LTE "24">
> <CFSET SmRmRq="6">
> <CFELSEIF Grp GTE "25" LTE "28">
> <CFSET SmRmRq="7">
> <CFELSE>
> <CFSET SmRmRq="8">
> </CFIF>
>
>
> Thank for your assisance in advance
>
> Axhind :)
>
>
> Post message: coldfusion-howto@egroups.com
> Subscribe:  coldfusion-howto-subscribe@egroups.com
> Unsubscribe:  coldfusion-howto-unsubscribe@egroups.com
> List owner:  coldfusion-howto-owner@egroups.com
> Group page: http://www.egroups.com/group/coldfusion-howto
>
>
>

I am setting a variable that depends on the value of another variable.

I need a variable that will give me a total and not a string
expression.

This is the variable I am working with.

<CFSET grp = (#form.adult# + #form.children#)>
Assuming the number of adults is 3 and the number of children is 1.

When I use this in a CFIF statement,instead of giving me the total as
a value it give me the string 3 + 1

when I do an output of the variable grp it shows the total as 4, but
in an if statement is shows a string.  Is there a cftag or procedure
which will total this for use in a cfif statement.

Sorry for the confusion.

Thanks in advance for any assistance,

Steve D.
Axhind :)

> The ColdFusion-HowTo egroup provides
> an email based forum in which members
> can read and post anything about
> ColdFusion and related topics like
> Tutorials, Tips, Problems, What's new etc.

I would like to announce a new tool, hopefully useful to ColdFusion
developers:

YesSoftware announced the pre-release version of CodeCharge, a
powerful code generation application that breaks new ground in easing
database publishing on the web. The program significantly reduces
costs and greatly accelerates the development of data-driven Web
applications, from simple dynamic web forms to Intranets, portals and
eCommerce sites.

The software generates high quality code in many server programming
languages such as Active Server Pages (ASP), Allaire ColdFusion
Markup Language (CFML), Java Server Pages (JSP), PHP & Perl.
Generated code runs on Windows and UNIX/Linux platforms and may be
freely distributed.

While helping experienced developers in reducing development cycles,
CodeCharge also offers an easy way to start, learn, and support
programming for the web. In a matter of hours, nonprogrammers can
create database-enabled web sites; beginners can study and modify
CodeCharge's robust code; and experienced developers can eliminate
repetitious, monotonous parts of their work while still retaining
full control over all code.

The flexibility built into CodeCharge lets developers use any
database to create dynamic, data-driven web sites in just about any
programming language.  Included are many samples, such as Online Book
Store, Classifieds, Employee Directory, Task Management System,
Yellow Pages, etc. These applications can be generated in any
supported language with just one click.

For visual site design, CodeCharge supports all HTML editors, thus
allowing users of Microsoft FrontPage, Allaire HomeSite, Adobe
GoLive, SoftQuad HoTMetaL Pro and other web design applications to
easily modify the look and feel of database driven web sites
generated with CodeCharge. Other major features include WAP support,
separation of code from content, page layout preview, site preview
and site diagram view.

Available now, the pre-release version of CodeCharge addresses the
needs of web developers who use products from Allaire (NASDAQ: ALLR),
IBM (NASDAQ: IBM), Microsoft (NASDAQ: MSFT), Sun Microsystems
(NASDAQ: SUNW), Red Hat (NASDAQ: RHAT), Macromedia (NASDAQ: MACR),
Adobe (NASDAQ: ADBE), ActiveState and SoftQuad among others.

For more information on CodeCharge, please visit
http://www.CodeCharge.com.

NOTE: Company and product names may be trademarks of their respective
companies.

As a newbie in coldfusion, I want to ask about the cfapplication.
I've tried to make my own cfapplication to be used in my website which has
member's area. I've noticed that cfapplication has several parameter for us
to set such as setclientcookies, clientmanagement, etc.

I just wanna know one thing, if I turnoff all the parameter at
cfapplication can my website work in general ?
When I turn of all parameters, my member's area cannot be accessed, which I
assumed because I set the clientmanagement parameter to NO. If I have no
member's area, will the cfapplication still work ?

This is my code :

<cfapplication name="webadmin" clientmanagement="No" setclientcookies="No">
<CFIF IsDefined("Form.LoggingOn")>
<CFQUERY NAME="CheckAdmin" DATASOURCE="#application.ds#">
                  SELECT  *
                  FROM    Admin
                  WHERE   Admin = '#Form.Admin#'
                  AND     Password = '#Form.Password#'
          </CFQUERY>
          <CFIF CheckAdmin.RecordCount>
                  <CFSET Client.LoggedIn = "Yes">
                  <CFSET Client.ID=CheckAdmin.ID_Admin>
                  <CFSET Client.Name=CheckAdmin.Admin>
                  <SCRIPT language="javascript">
                  document.location.href ="login.cfm"
                  </SCRIPT>
          <CFELSE>
                  <CFSET Client.LoggedIn="No">
                  <SCRIPT language="javascript">
                  document.location.href = "index.cfm"
                  </SCRIPT>
          </CFIF>
</CFIF>
<CFIF NOT IsDefined("application.initialized") OR 1>
          <CFINCLUDE TEMPLATE="Commonfiles/variables.cfm">
</CFIF>
<CFIF IsDefined("Logout")>
          <CFSET Client.LoggedIn="No">
          <SCRIPT language="javascript">
                  document.location.href = "index.cfm"
                  </SCRIPT>
</CFIF>

Thanx a lot
==============================
SYAFRIL
Graphic Design Department
DAKSACIPTA
Ph.     (62-21) 3914411
Fax.    (62-21) 3914411
http://www.daksacipta.web.id
syafril@...
=======================

[Non-text portions of this message have been removed]

when u have two conditions in a IF ELSE statement you have to use an
operator like AND or OR:
see the code below:

> <CFSET Grp=(#form.adult# + #children#)>
>
> <CFSET SmRmRq="0">
>
> <CFIF Grp LTE "4">
> <CFSET SmRmRq="1">
> <CFELSEIF Grp GTE "5" [(AND or OR) depends what u want] LTE "8">
> <CFSET SmRmRq="2">
> <CFELSEIF Grp GTE "9" [(AND or OR) depends what u want] LTE "12">
> <CFSET SmRmRq="3">
> <CFELSEIF Grp GTE "13" [(AND or OR) depends what u want] LTE "16">
> <CFSET SmRmRq="4">
> <CFELSEIF Grp GTE "17"[(AND or OR) depends what u want]  LTE "20">
> <CFSET SmRmRq="5">
> <CFELSEIF Grp GTE "21" [(AND or OR) depends what u want] LTE "24">
> <CFSET SmRmRq="6">
> <CFELSEIF Grp GTE "25" [(AND or OR) depends what u want] LTE "28">
> <CFSET SmRmRq="7">
> <CFELSE>
> <CFSET SmRmRq="8">
> </CFIF>

----- Original Message -----
From: "Steve Doran" <sandsint@...>
To: <coldfusion-howto@egroups.com>
Sent: Tuesday, January 16, 2001 5:34 AM
Subject: [coldfusion-howto] setting a variable


> I am trying to set a variable that will change depending on the
> number
> of people in the party.  Below is the code i am working with.  I have
> tried "parentheses", "and", "or" and it will still not work.  Does
> anyone
> have any idea what i am doing wrong.  This looks real simple not to
> work.
>
> <CFSET Grp=(#form.adult# + #children#)>
>
> <CFSET SmRmRq="0">
>
> <CFIF Grp LTE "4">
> <CFSET SmRmRq="1">
> <CFELSEIF Grp GTE "5" LTE "8">
> <CFSET SmRmRq="2">
> <CFELSEIF Grp GTE "9" LTE "12">
> <CFSET SmRmRq="3">
> <CFELSEIF Grp GTE "13" LTE "16">
> <CFSET SmRmRq="4">
> <CFELSEIF Grp GTE "17" LTE "20">
> <CFSET SmRmRq="5">
> <CFELSEIF Grp GTE "21" LTE "24">
> <CFSET SmRmRq="6">
> <CFELSEIF Grp GTE "25" LTE "28">
> <CFSET SmRmRq="7">
> <CFELSE>
> <CFSET SmRmRq="8">
> </CFIF>
>
>
> Thank for your assisance in advance
>
> Axhind :)
>
>
> Post message: coldfusion-howto@egroups.com
> Subscribe:  coldfusion-howto-subscribe@egroups.com
> Unsubscribe:  coldfusion-howto-unsubscribe@egroups.com
> List owner:  coldfusion-howto-owner@egroups.com
> Group page: http://www.egroups.com/group/coldfusion-howto
>
>
>
>

1.  There is no need to set your variable to zero at the beginning there.
2.  There is no need to treat your numbers as strings
3.  Your expressions are incomplete

Here is an example that addresses your needs.  I threw it on a page so you
can see it work:

http://www.i-magery.com/cfexample

Here is the code I used:

<CFSET datTing = 3>

<CFIF #datTing# GTE 1 AND #datTing# LTE 4>
   <CFSET disTing = 1>
<CFELSEIF #datTing# GTE 5 AND #datTing# LTE 8>
   <CFSET disTing = 2>
</CFIF>

<CFOUTPUT>
disTing: #disTing#<BR>
DatTing: #datTing#<BR><BR>
</CFOUTPUT>

I hope that I helped!

:)

Michael E. Cummins
http://www.i-magery.com




-----Original Message-----
From: Steve Doran [mailto:sandsint@...]
Sent: Monday, January 15, 2001 4:34 PM
To: coldfusion-howto@egroups.com
Subject: [coldfusion-howto] setting a variable


I am trying to set a variable that will change depending on the
number
of people in the party.  Below is the code i am working with.  I have
tried "parentheses", "and", "or" and it will still not work.  Does
anyone
have any idea what i am doing wrong.  This looks real simple not to
work.

<CFSET Grp=(#form.adult# + #children#)>

<CFSET SmRmRq="0">

<CFIF Grp LTE "4">
<CFSET SmRmRq="1">
<CFELSEIF Grp GTE "5" LTE "8">
<CFSET SmRmRq="2">
<CFELSEIF Grp GTE "9" LTE "12">
<CFSET SmRmRq="3">
<CFELSEIF Grp GTE "13" LTE "16">
<CFSET SmRmRq="4">
<CFELSEIF Grp GTE "17" LTE "20">
<CFSET SmRmRq="5">
<CFELSEIF Grp GTE "21" LTE "24">
<CFSET SmRmRq="6">
<CFELSEIF Grp GTE "25" LTE "28">
<CFSET SmRmRq="7">
<CFELSE>
<CFSET SmRmRq="8">
</CFIF>


Thank for your assisance in advance

Axhind :)


Post message: coldfusion-howto@egroups.com
Subscribe:  coldfusion-howto-subscribe@egroups.com
Unsubscribe:  coldfusion-howto-unsubscribe@egroups.com
List owner:  coldfusion-howto-owner@egroups.com
Group page: http://www.egroups.com/group/coldfusion-howto

I am trying to set a variable that will change depending on the
number
of people in the party.  Below is the code i am working with.  I have
tried "parentheses", "and", "or" and it will still not work.  Does
anyone
have any idea what i am doing wrong.  This looks real simple not to
work.

<CFSET Grp=(#form.adult# + #children#)>

<CFSET SmRmRq="0">

<CFIF Grp LTE "4">
<CFSET SmRmRq="1">
<CFELSEIF Grp GTE "5" LTE "8">
<CFSET SmRmRq="2">
<CFELSEIF Grp GTE "9" LTE "12">
<CFSET SmRmRq="3">
<CFELSEIF Grp GTE "13" LTE "16">
<CFSET SmRmRq="4">
<CFELSEIF Grp GTE "17" LTE "20">
<CFSET SmRmRq="5">
<CFELSEIF Grp GTE "21" LTE "24">
<CFSET SmRmRq="6">
<CFELSEIF Grp GTE "25" LTE "28">
<CFSET SmRmRq="7">
<CFELSE>
<CFSET SmRmRq="8">
</CFIF>


Thank for your assisance in advance

Axhind :)

Terion: I'm leaving shortly so i've only had a quick look, but this looks
like more of an html issue than a CF issue.  Although it may seem like
overkill, give Clinic, Phone, etc... each a separate <tr> then you can get
more control using align, valign, cellpadding, cellspacing, colspan, etc....
set table border equal to one while you are doing this so it is visible. I
think you'll find this to be a good approach. ... not sure what you are
doing with MENU - nothing seems to be in need of outputting there....
further down you start a query output inside a <td> and finish it after the
table - not sure why...
don't know enough about fusebox to comment on the rest of the code....

Patrick

-----Original Message-----
From: Terion Miller [mailto:TMiller@...]
Sent: Wednesday, January 10, 2001 3:00 PM
To: 'coldfusion-howto@egroups.com'
Subject: RE: [coldfusion-howto] cfoutput's and tables


here is my code...it kind of works how I want.  I am working with fusebox
methodology don't know if that makes a difference.

As you will see I had to use a lot of generic output tags and still the
table themselves aren't really formating the info as I would like.

<cfinclude template = "../app_globals.cfm">
<cfinclude template = "../app_locals.cfm">
<cf_formURL2attributes>
<!--- VALIDATES USER LOGIN --->
<cfif ParameterExists(form.WebUN)>
<cfif validatelogin.RecordCount IS 0>
   <cflocation url="#thispage#?fuseaction=error">
   <CFABORT>
</cfif>
       </cfif>
<cfif IsDefined(form.WebPassword)>
     <cfif WebPassword IS #form.webpassword# AND WebUN IS  #form.webUN# AND
PatMng IS 1>
          <cfset session.IsAuthenticated = true>
       </cfif>
</cfif>
<!--- END VALIDATION --->
<head>
       <title>Display User Information</title>
</head>
<body bgcolor="White" text="Black" link="Blue" vlink="Gray">

<!--- HEADER TAGS --->
<cfoutput><cfinclude template="/images/headers/welcome.htm"><br></cfoutput>
<!--- END HEADER --->
<br>
<!--- LEFT SIDE MENU AREA --->

<table>
       <tr>
             <td>
                   <cfoutput>
                   <table width="200" cellspacing="3" cellpadding="3"
align="left">
                         <tr>
                         <td height="600" rowspan="2" align="left"
valign="top" bgcolor="##0080C0">Menu Options<br>
                                     MENU <br>
                                     MENU<bR>
                                     MENU<br>
                                     MENU<bR>
                                     MENU<bR>
                                     MENU<bR>
                                     MENU<bR>
                                     MENU<bR>
                         </td>
                         </tr>
                   </table>
                   </cfoutput>
       </td>
<!--- END LEFT MENU AREA --->

<!--- CENTER AREA --->
<td>
<cfoutput query="dspUinfo">
             <table width="350" border="0" align="left">
                   <tr>
                         <td>
                               <font face="'Trebuchet
MS',Verdana,Arial" size="2" color="Black">Welcome
<b>#FirstName# #LastName#</b>  Today is
<i>#DateFormat(Client.LastVisit)#</i><br>
<font size="2">
Clinic: <b>#FacilityName#</b><br>
Phone :#Phone#<br>
Fax: #Fax#<br>
Pager: #Pager#<br>
Email: <a href="mailto:#EmailAddress#">#EmailAddress#</a>
<!--- these breaks are needed to keep clinic associated with user from
populating two td's --->
<br><br><br><br><br><br><br>

</font>
                         </td>
                   </tr>
       </table>
</cfoutput>
</td>
<!--- END CENTER AREA --->

<!--- RIGHT AREA --->

<td>
<br><br>
<table><tr><td><cfoutput><font face="Trebuchet MS" size="2"
color="Black"><b>Clinics Associated with your User Name:</b></font>
<hr align="left" width="220" noshade></cfoutput>

<br><cfoutput query="dsp_clinicinfo">
<font face="Trebuchet MS" size="2" color="##000008">
<a
href="index.cfm?clinic=#facilityname#&fuseaction=dspclinic">#FacilityName#</
a><br></font></td></tr></table>
</cfoutput>

</td></tr></table>




</body>
</html>

-----Original Message-----
From: Patrick Harkins [mailto:patrick@...]
Sent: Wednesday, January 10, 2001 12:18 PM
To: 'coldfusion-howto@egroups.com'
Subject: RE: [coldfusion-howto] cfoutput's and tables


not to presume, but often one query will return everything you need, so look
into that before you go too far.

...note that the query loop is inside the table, so you could easily loop
more than one query in the same table, or just do a new table - depending on
your needs.

You would have to provide more detail about what you are trying to do if you
want more specific advice.

If you mean nested loops I can advise on that as well.
You can close the output tag inside the loop, do a query on a value from the
looped query, output that, reopen the output and continue out putting the
original query. a handy trick at times....

Patrick

-----Original Message-----
From: Terion Miller [mailto:TMiller@...]
Sent: Wednesday, January 10, 2001 11:47 AM
To: 'coldfusion-howto@egroups.com'
Subject: RE: [coldfusion-howto] cfoutput's and tables


But I'm using 3 different queries on one page?





[Non-text portions of this message have been removed]


Post message: coldfusion-howto@egroups.com
Subscribe:  coldfusion-howto-subscribe@egroups.com
Unsubscribe:  coldfusion-howto-unsubscribe@egroups.com
List owner:  coldfusion-howto-owner@egroups.com
Group page: http://www.egroups.com/group/coldfusion-howto
<http://www.egroups.com/group/coldfusion-howto>




eGroups Sponsor

<http://rd.yahoo.com/M=164783.1232565.2856565.2/S=1702208619:N/A=517097/*htt
p://www.getsmart.com/mortgage/HomeBanner?BANNERNAME=1073111108912> Click
here for GetSmart.com's MortgageFinder.

Post message: coldfusion-howto@egroups.com
Subscribe:  coldfusion-howto-subscribe@egroups.com
Unsubscribe:  coldfusion-howto-unsubscribe@egroups.com
List owner:  coldfusion-howto-owner@egroups.com
Group page: http://www.egroups.com/group/coldfusion-howto
<http://www.egroups.com/group/coldfusion-howto>






[Non-text portions of this message have been removed]

here is my code...it kind of works how I want.  I am working with fusebox
methodology don't know if that makes a difference.

As you will see I had to use a lot of generic output tags and still the
table themselves aren't really formating the info as I would like.

<cfinclude template = "../app_globals.cfm">
<cfinclude template = "../app_locals.cfm">
<cf_formURL2attributes>
<!--- VALIDATES USER LOGIN --->
<cfif ParameterExists(form.WebUN)>
<cfif validatelogin.RecordCount IS 0>
   <cflocation url="#thispage#?fuseaction=error">
   <CFABORT>
  </cfif>
	 </cfif>
<cfif IsDefined(form.WebPassword)>
     <cfif WebPassword IS #form.webpassword# AND WebUN IS  #form.webUN# AND
PatMng IS 1>
          <cfset session.IsAuthenticated = true>
	 </cfif>
</cfif>
<!--- END VALIDATION --->
<head>
	 <title>Display User Information</title>
</head>
<body bgcolor="White" text="Black" link="Blue" vlink="Gray">

<!--- HEADER TAGS --->
<cfoutput><cfinclude template="/images/headers/welcome.htm"><br></cfoutput>
<!--- END HEADER --->
<br>
<!--- LEFT SIDE MENU AREA --->

<table>
	 <tr>
		 <td>
			 <cfoutput>
			 <table width="200" cellspacing="3" cellpadding="3"
align="left">
				 <tr>
				 <td height="600" rowspan="2" align="left"
valign="top" bgcolor="##0080C0">Menu Options<br>
						 MENU <br>
						 MENU<bR>
						 MENU<br>
						 MENU<bR>
						 MENU<bR>
						 MENU<bR>
						 MENU<bR>
						 MENU<bR>
				 </td>
				 </tr>
			 </table>
			 </cfoutput>
	 </td>
<!--- END LEFT MENU AREA --->

<!--- CENTER AREA --->
<td>
<cfoutput query="dspUinfo">
		 <table width="350" border="0" align="left">
			 <tr>
				 <td>
					 <font face="'Trebuchet
MS',Verdana,Arial" size="2" color="Black">Welcome
<b>#FirstName# #LastName#</b>  Today is
<i>#DateFormat(Client.LastVisit)#</i><br>
<font size="2">
Clinic: <b>#FacilityName#</b><br>
Phone :#Phone#<br>
Fax: #Fax#<br>
Pager: #Pager#<br>
Email: <a href="mailto:#EmailAddress#">#EmailAddress#</a>
<!--- these breaks are needed to keep clinic associated with user from
populating two td's --->
<br><br><br><br><br><br><br>

</font>
				 </td>
			 </tr>
	 </table>
</cfoutput>
</td>
<!--- END CENTER AREA --->

<!--- RIGHT AREA --->

<td>
<br><br>
<table><tr><td><cfoutput><font face="Trebuchet MS" size="2"
color="Black"><b>Clinics Associated with your User Name:</b></font>
<hr align="left" width="220" noshade></cfoutput>

<br><cfoutput query="dsp_clinicinfo">
<font face="Trebuchet MS" size="2" color="##000008">
<a
href="index.cfm?clinic=#facilityname#&fuseaction=dspclinic">#FacilityName#</
a><br></font></td></tr></table>
</cfoutput>

</td></tr></table>




</body>
</html>

-----Original Message-----
From: Patrick Harkins [mailto:patrick@...]
Sent: Wednesday, January 10, 2001 12:18 PM
To: 'coldfusion-howto@egroups.com'
Subject: RE: [coldfusion-howto] cfoutput's and tables


not to presume, but often one query will return everything you need, so look
into that before you go too far.

...note that the query loop is inside the table, so you could easily loop
more than one query in the same table, or just do a new table - depending on
your needs.

You would have to provide more detail about what you are trying to do if you
want more specific advice.

If you mean nested loops I can advise on that as well.
You can close the output tag inside the loop, do a query on a value from the
looped query, output that, reopen the output and continue out putting the
original query. a handy trick at times....

Patrick

-----Original Message-----
From: Terion Miller [mailto:TMiller@...]
Sent: Wednesday, January 10, 2001 11:47 AM
To: 'coldfusion-howto@egroups.com'
Subject: RE: [coldfusion-howto] cfoutput's and tables


But I'm using 3 different queries on one page?





[Non-text portions of this message have been removed]


Post message: coldfusion-howto@egroups.com
Subscribe:  coldfusion-howto-subscribe@egroups.com
Unsubscribe:  coldfusion-howto-unsubscribe@egroups.com
List owner:  coldfusion-howto-owner@egroups.com
Group page: http://www.egroups.com/group/coldfusion-howto

not to presume, but often one query will return everything you need, so look
into that before you go too far.

...note that the query loop is inside the table, so you could easily loop
more than one query in the same table, or just do a new table - depending on
your needs.

You would have to provide more detail about what you are trying to do if you
want more specific advice.

If you mean nested loops I can advise on that as well.
You can close the output tag inside the loop, do a query on a value from the
looped query, output that, reopen the output and continue out putting the
original query. a handy trick at times....

Patrick

-----Original Message-----
From: Terion Miller [mailto:TMiller@...]
Sent: Wednesday, January 10, 2001 11:47 AM
To: 'coldfusion-howto@egroups.com'
Subject: RE: [coldfusion-howto] cfoutput's and tables


But I'm using 3 different queries on one page?





[Non-text portions of this message have been removed]

But I'm using 3 different queries on one page?

-----Original Message-----
From: Patrick Harkins [mailto:patrick@...]
Sent: Wednesday, January 10, 2001 11:43 AM
To: 'coldfusion-howto@egroups.com'
Subject: RE: [coldfusion-howto] cfoutput's and tables


...You want to do a cfloop query  - inside the <table> tag where the dynamic
content begins. Then do a <cfoutput> surrounding the <tr> for each row you
wish to display. do a <td> for each static element or query field you wish
to output.
E.g. (snipped, so some of the layout code will not be applicable)


<table cellpadding="3" cellspacing="0" border="0" width="100%">
  <cfloop query="getcontract">
   <cfoutput>
    <tr>
     <td valign="top" width="100">
     <font face="ms sans serif" size="2">
     Grower Name:
     </font>
     </td>
     <td valign="top" colspan="5" width="500">
     <font face="ms sans serif" size="2">
     <b>
     #legalname#
     </b>
     </font>
     </td>
    </tr>
   </cfoutput>
  </cfloop>
</table>

you can use CSS to handle the font information and reduce your file size -
just put this before your table
<style type="text/css">
    td  {

     font-size : x-small;
     font-family : sans-serif;
    }
</style>

-----Original Message-----
From: Terion Miller [mailto:TMiller@...]
Sent: Wednesday, January 10, 2001 10:53 AM
To: 'coldfusion-howto@egroups.com'
Subject: [coldfusion-howto] cfoutput's and tables


I've never had this problem before...but I'm trying to output some data into
tables (html)
and am having a problem getting the tables to be recognized.  Trying to get
the page layout is impossible, but I've never noticed this problem before.
the table is read if it is inside a cfoutput tag, if I try puttting the
cfoutput in the <td> tags, it won't work.  and if I get one out put to work
by putting the cfoutput start tag outside the table, then the next <td>
doesn't show....each <Td> has a different query associated with it...
and ideas?

Terion K. Miller
IS Development
DaVita, Inc
Phone: 904-738-1809 x. 2338
Email: tmiller@...




eGroups Sponsor

<http://rd.yahoo.com/M=170602.1266299.2866456.2/S=1702208619:N/A=551014/?htt
p://www.debticated.com> www.debticated.com

Post message: coldfusion-howto@egroups.com
Subscribe:  coldfusion-howto-subscribe@egroups.com
Unsubscribe:  coldfusion-howto-unsubscribe@egroups.com
List owner:  coldfusion-howto-owner@egroups.com
Group page: http://www.egroups.com/group/coldfusion-howto
<http://www.egroups.com/group/coldfusion-howto>






[Non-text portions of this message have been removed]


Post message: coldfusion-howto@egroups.com
Subscribe:  coldfusion-howto-subscribe@egroups.com
Unsubscribe:  coldfusion-howto-unsubscribe@egroups.com
List owner:  coldfusion-howto-owner@egroups.com
Group page: http://www.egroups.com/group/coldfusion-howto

...You want to do a cfloop query  - inside the <table> tag where the dynamic
content begins. Then do a <cfoutput> surrounding the <tr> for each row you
wish to display. do a <td> for each static element or query field you wish
to output.
E.g. (snipped, so some of the layout code will not be applicable)


<table cellpadding="3" cellspacing="0" border="0" width="100%">
  <cfloop query="getcontract">
   <cfoutput>
    <tr>
     <td valign="top" width="100">
     <font face="ms sans serif" size="2">
     Grower Name:
     </font>
     </td>
     <td valign="top" colspan="5" width="500">
     <font face="ms sans serif" size="2">
     <b>
     #legalname#
     </b>
     </font>
     </td>
    </tr>
   </cfoutput>
  </cfloop>
</table>

you can use CSS to handle the font information and reduce your file size -
just put this before your table
<style type="text/css">
    td  {

     font-size : x-small;
     font-family : sans-serif;
    }
</style>

-----Original Message-----
From: Terion Miller [mailto:TMiller@...]
Sent: Wednesday, January 10, 2001 10:53 AM
To: 'coldfusion-howto@egroups.com'
Subject: [coldfusion-howto] cfoutput's and tables


I've never had this problem before...but I'm trying to output some data into
tables (html)
and am having a problem getting the tables to be recognized.  Trying to get
the page layout is impossible, but I've never noticed this problem before.
the table is read if it is inside a cfoutput tag, if I try puttting the
cfoutput in the <td> tags, it won't work.  and if I get one out put to work
by putting the cfoutput start tag outside the table, then the next <td>
doesn't show....each <Td> has a different query associated with it...
and ideas?

Terion K. Miller
IS Development
DaVita, Inc
Phone: 904-738-1809 x. 2338
Email: tmiller@...




eGroups Sponsor

<http://rd.yahoo.com/M=170602.1266299.2866456.2/S=1702208619:N/A=551014/?htt
p://www.debticated.com> www.debticated.com

Post message: coldfusion-howto@egroups.com
Subscribe:  coldfusion-howto-subscribe@egroups.com
Unsubscribe:  coldfusion-howto-unsubscribe@egroups.com
List owner:  coldfusion-howto-owner@egroups.com
Group page: http://www.egroups.com/group/coldfusion-howto
<http://www.egroups.com/group/coldfusion-howto>






[Non-text portions of this message have been removed]

Thanks Joel!, I did figure out that if you put everything (text, images etc)
inside of generic cfoutput tags it will show up too.


-----Original Message-----
From: Joel Flint [mailto:flintjd@...]
Sent: Wednesday, January 10, 2001 11:26 AM
To: coldfusion-howto@egroups.com
Subject: RE: [coldfusion-howto] cfoutput's and tables


Try to use a cfloop for each query and one cfoutput on the outside of the
table.

Hope this helps!

> -----Original Message-----
> From: Terion Miller [mailto:TMiller@...]
> Sent: Wednesday, January 10, 2001 3:53 PM
> To: 'coldfusion-howto@egroups.com'
> Subject: [coldfusion-howto] cfoutput's and tables
>
>
> I've never had this problem before...but I'm trying to output
> some data into
> tables (html)
> and am having a problem getting the tables to be recognized.
> Trying to get
> the page layout is impossible, but I've never noticed this
> problem before.
> the table is read if it is inside a cfoutput tag, if I try
> puttting the
> cfoutput in the <td> tags, it won't work.  and if I get one
> out put to work
> by putting the cfoutput start tag outside the table, then the
> next <td>
> doesn't show....each <Td> has a different query associated with it...
> and ideas?
>
> Terion K. Miller
> IS Development
> DaVita, Inc
> Phone: 904-738-1809 x. 2338
> Email: tmiller@...
>
>
>
> Post message: coldfusion-howto@egroups.com
> Subscribe:  coldfusion-howto-subscribe@egroups.com
> Unsubscribe:  coldfusion-howto-unsubscribe@egroups.com
> List owner:  coldfusion-howto-owner@egroups.com
> Group page: http://www.egroups.com/group/coldfusion-howto
>
>
>

Post message: coldfusion-howto@egroups.com
Subscribe:  coldfusion-howto-subscribe@egroups.com
Unsubscribe:  coldfusion-howto-unsubscribe@egroups.com
List owner:  coldfusion-howto-owner@egroups.com
Group page: http://www.egroups.com/group/coldfusion-howto

Try to use a cfloop for each query and one cfoutput on the outside of the
table.

Hope this helps!

> -----Original Message-----
> From: Terion Miller [mailto:TMiller@...]
> Sent: Wednesday, January 10, 2001 3:53 PM
> To: 'coldfusion-howto@egroups.com'
> Subject: [coldfusion-howto] cfoutput's and tables
>
>
> I've never had this problem before...but I'm trying to output
> some data into
> tables (html)
> and am having a problem getting the tables to be recognized.
> Trying to get
> the page layout is impossible, but I've never noticed this
> problem before.
> the table is read if it is inside a cfoutput tag, if I try
> puttting the
> cfoutput in the <td> tags, it won't work.  and if I get one
> out put to work
> by putting the cfoutput start tag outside the table, then the
> next <td>
> doesn't show....each <Td> has a different query associated with it...
> and ideas?
>
> Terion K. Miller
> IS Development
> DaVita, Inc
> Phone: 904-738-1809 x. 2338
> Email: tmiller@...
>
>
>
> Post message: coldfusion-howto@egroups.com
> Subscribe:  coldfusion-howto-subscribe@egroups.com
> Unsubscribe:  coldfusion-howto-unsubscribe@egroups.com
> List owner:  coldfusion-howto-owner@egroups.com
> Group page: http://www.egroups.com/group/coldfusion-howto
>
>
>

I've never had this problem before...but I'm trying to output some data into
tables (html)
and am having a problem getting the tables to be recognized.  Trying to get
the page layout is impossible, but I've never noticed this problem before.
the table is read if it is inside a cfoutput tag, if I try puttting the
cfoutput in the <td> tags, it won't work.  and if I get one out put to work
by putting the cfoutput start tag outside the table, then the next <td>
doesn't show....each <Td> has a different query associated with it...
and ideas?

Terion K. Miller
IS Development
DaVita, Inc
Phone: 904-738-1809 x. 2338
Email: tmiller@...

hi, i'm a newcomer in coldfusion from indonesia. And I want to ask several
questions about coldfusion script.

I am trying to make a login system for member area, which have several
links that will appear only for members. It works until I found that
whenever I've logout and press the back button on IE on purpose (or maybe
not), I will be back to the members' only page with all the members link
still active. I even can logout again. And if i press the back button
again, same things happen. All I want is whenever the back button on IE is
pressed, the message that i've set ("you have to re-login") appears and
they have to re-login. The message can only  be displayed if I press the
refresh button on purpose.

I'm getting frustrated with this condition. I've tried several methods
which I read from several tutorials such as using cfheader, javascript,
cflocation with urlencode, etc. but those only work when I tested it on my
computer (using PWS and CFServer). But they never work on the hosting site.

Can someone put their experience or idea how to do it automatically ?

Thanx,
AV
==============================
SYAFRIL
Graphic Design Department
DAKSACIPTA
Ph.     (62-21) 3914411
Fax.    (62-21) 3914411
http://www.daksacipta.web.id
syafril@...
=======================

[Non-text portions of this message have been removed]

Hi All,

Though I have cleared the exam of BrainBench and eCertifications.com but I
am confused about the answers to the following questions. Could you people
help me out!

1. When creating a CFX tag using Java, what does the
\cfusion\java\class\cfx.jar file contain?

A. Transaction Object, CF Object, Query Object
B. Request Object, Response Object, Query Object
C. Step Object, Request Object, Responce Object
D. Process Object, Status Object, Request Object
E. Status Object, Response Object, CFQuery Object

Answer: ?

2. Sample Code:
1 <CFIF NOT IsAuthenticate("Admin")>
2 <CFTRY>
3 <CFAUTHENTICATE SECURITYCONTEXT="Edge" USERNAME=#user# PASSWORD=#pwd#>
4 <CFCATCH TYPE="Security">
5 Access denied. </CFCATCH></CFTRY></CFIF>
   Which of the lines in the above code contains an error?

A. Line 3
B. Line 1
C. Line 5
D. Line 4
E. Line 2

Answer: ?

3. 1  < (Less Than)
2 > (Greater Than)
3 ' (Single Quote)
4 " (Double Quote)
5 % (Percent)
   The function XMLFormat(string) is used to create an XML safe string. Which
of the following characters does it filter?

A. 1,2,3
B. 3, 4
C. 1,2,3,4
D. 3,4,5
E. 1,2,5

Answer: ?

4. Which of the following is a list of valid CFCACHE parameters?

A. ClientCache, Write, Flush, and Cache
B. Cache, Optimal, Flush, and ClientCache
C. Cache, Write, Read, and Optimal
D. Write, Flush, ClientCache, and Optimal
E. Cache, Write, Flush, and Optimal

Answer: ?

5. What is the name of the page that is similar to the application.cfm but
is run after the main page is done?

A. Application2.cfm
B. ApplicationEnd.cfm
C. OnPageEnd.cfm
D. OnRequestEnd.cfm
E. PageEnd.cfm

Answer: ?

6. Sample Code:

<CFSET Txt = Evaluate("CALLER.#ATTRIBUTES.VariableName#")>
<CFSET Txt = Replace("#Txt#", "_", "x", "ALL")>
<CFSET Txt = SetVariable("CALLER.#ATTRIBUTES.VariableName#",Txt)>
   When the above module is called with <cfmodule template="sample.cfm"
VariableName="Text_Var">, what is the result?

A. Recurse the caller routine until all characters are x.
B. Blank the value of the variable Text_Var.
C. Double call the caller routine backwards.
D. Remove all _ symbols from the contents of the variable Text_Var.
E. Change the name of the variable Text_Var to TextVar

Answer: ?

7. Which of the following a valid ACTION within the CFTRANSATION tag?

A:   END
B:   ROLLOVER
C:   READ
D:   COMMIT

Answer: ?

8. When working with CFSLIDER attributes, <CFSLIDER NAME="Lyk" RANGE="1,10"
SCALE="1" VALUE="5">, the VALUE attribute indicates

A:   the number of values.
B:   the starting value.
C:   the highest real value.
D:   none of the above.

Answer: ?

9. While using the CFFILE tag with the UPLOAD action, which File variable is
not matched correctly with the return?

A:   File.FileExisted: indicates whether a file already exists in the
specific directory
B:   File.ServerFile: the filename a file was saved as on the server
C:   File.ServerFileName: the filname and extension of the file that was
uploaded to the server
D:   File.OldFileSize: the size of the file that was overwritten by the
uploaded file

Answer: ?

10. To reduce the file size of ColdFusion templates by reducing white space
from the Administrator select ____ within the Server section.

A:   Limit file size
B:   Enforce suppression
C:   Suppress white space by default
D:   Eliminate white space

Answer: ?

11. HTML and JAVASCRIPT are supported within an error template.

A:   True
B:   False

Answer: ?

12. In a SQL query, if a subquery will return more than one result, it must
be placed in the

A:   WHERE clause
B:   FROM clause
C:   SELECT clause
D:   GROUP by clause

Answer: ?

13. Which of the following is false regarding the <CFOBJECT> tag?

a. Skip Question
b. Using CFOBJECT, any automation server object type that is currently
registered on a machine can be invoked
c. CFOBJECT allows you to create and use COM (Component Object Model)
objects
d. Using CFOBJECT, you can use a utility like Microsoft's OLEView to browse
COM objects
e. All the above

Answer: ?

14. What is the purpose of the Delay Evaluation (DE) function in Cold
Fusion?

a. Skip Question
b. Returns its argument with double quotes wrapped around it and all double
quotes inside it escaped
c. Prevents the evaluation of a string as an expression when it is passed as
an argument to IIf or Evaluate
d. Both a and b
e. None of the above

Answer: ?

15. What is the purpose of the Network Listener Module (NLM)?

a. Skip Question
b. NLM is a Java applet used to listen for incoming messages and redirect
them to the standard Cold Fusion server
c. NLM is only used on the Unix Operating System
d. NLM is a stand-alone program that acts as a network front-end for the
standard Cold Fusion server
e. All the above

Answer: ?

16. Which of the following statements is false regarding the difference
between CFScript and JavaScript?

a. Skip Question
b. CFScript uses ColdFusion expressions, which are neither a subset nor a
superset of JavaScript expressions
c. CFScript is case-sensitive
d. In CFScript, assignments are statements, not expressions
e. In CFScript, some implicit objects are not available, such as Window and
Document

Answer: ?
Answer: C

17. Which of the structure functions listed below do all of the following:
1) contains data, 2) returns
TRUE if the structure contains no data, 3) returns FALSE if it does contain
data?

a. Skip Question
b. StructCopy
c. StructUpdate
d. StructKeyExists
e. StructIsEmpty

Answer: ?
Answer: E

18. What are the two types of custom tags available in Cold Fusion 4.01?

a. Skip Question
b. Local and shared custom tags
c. Local and client custom tags
d. Private and public custom tags
e. Client and shared custom tags

Answer: ?
Answer: C

Regards,
Bitto

Hi, how would I get a phone number to format when it outputs to look like a
phone number?
they are in the database as a straight 7 character ---->9045551212 but I
want them to output on the page to look like a phone number ------> (904)
555-1212

Anyone know?
Thanks.

-----Original Message-----
From: Terion Miller [mailto:TMiller@...]
Sent: Thursday, January 04, 2001 3:54 PM
To: 'coldfusion-howto@egroups.com'
Subject: RE: [coldfusion-howto] General help with Login/form attribute
pas sing


Hi, how would I get a phone number to format when it outputs to look like a
phone number?
they are in the database as a straight 7 character ---->9045551212 but I
want them to output on the page to look like a phone number ------> (904)
555-1212

Anyone know?
Thanks.


-----Original Message-----
From: Joel Flint [mailto:flintjd@...]
Sent: Wednesday, December 27, 2000 4:18 PM
To: coldfusion-howto@egroups.com
Subject: RE: [coldfusion-howto] General help with Login/form attribute
pas sing


Make sure that your form is using the "post" method. This will allow you to
use the Form scope, otherwise try the URL scope. Hope this helps.

> -----Original Message-----
> From: Terion Miller [mailto:TMiller@...]
> Sent: Wednesday, December 27, 2000 9:05 PM
> To: 'coldfusion-howto@egroups.com'
> Subject: [coldfusion-howto] General help with Login/form attribute
> passing
>
>
> Hello Group.
> I am looking for general help with various coldfusion related
> problems.
>      How do I keep form variables to use in a query/output query?
>      I've tried form.variable as in select * where variable =
> form.variable
> but that doesn't work.
>      and I am writing this app in Fusebox so I'm using the
> <cf_formURL2attributes> but still my app      doesn't seem to
> know who is
> logged in from one page to the next.
>
> Thanks So Much,
> Terion Miller
>
>
>
> -------------------------- eGroups Sponsor
> -------------------------~-~>
> Download Net2Phone's free software to make FREE calls anywhere within
> the US from your PC now! Get great low rates on international calls!
> http://click.egroups.com/1/10923/1/_/25703/_/977951447/
> --------------------------------------------------------------
> -------_->
>
> * Subscribe: coldfusion-howto-subscribe@egroups.com
> * Un-Subscribe: coldfusion-howto-unsubscribe@egroups.com
>
>
>
>
>


* Subscribe: coldfusion-howto-subscribe@egroups.com
* Un-Subscribe: coldfusion-howto-unsubscribe@egroups.com

Post message: coldfusion-howto@egroups.com
Subscribe:  coldfusion-howto-subscribe@egroups.com
Unsubscribe:  coldfusion-howto-unsubscribe@egroups.com
List owner:  coldfusion-howto-owner@egroups.com
Group page: http://www.egroups.com/group/coldfusion-howto

Hi, how would I get a phone number to format when it outputs to look like a
phone number?
they are in the database as a straight 7 character ---->9045551212 but I
want them to output on the page to look like a phone number ------> (904)
555-1212

Anyone know?
Thanks.


-----Original Message-----
From: Joel Flint [mailto:flintjd@...]
Sent: Wednesday, December 27, 2000 4:18 PM
To: coldfusion-howto@egroups.com
Subject: RE: [coldfusion-howto] General help with Login/form attribute
pas sing


Make sure that your form is using the "post" method. This will allow you to
use the Form scope, otherwise try the URL scope. Hope this helps.

> -----Original Message-----
> From: Terion Miller [mailto:TMiller@...]
> Sent: Wednesday, December 27, 2000 9:05 PM
> To: 'coldfusion-howto@egroups.com'
> Subject: [coldfusion-howto] General help with Login/form attribute
> passing
>
>
> Hello Group.
> I am looking for general help with various coldfusion related
> problems.
>      How do I keep form variables to use in a query/output query?
>      I've tried form.variable as in select * where variable =
> form.variable
> but that doesn't work.
>      and I am writing this app in Fusebox so I'm using the
> <cf_formURL2attributes> but still my app      doesn't seem to
> know who is
> logged in from one page to the next.
>
> Thanks So Much,
> Terion Miller
>
>
>
> -------------------------- eGroups Sponsor
> -------------------------~-~>
> Download Net2Phone's free software to make FREE calls anywhere within
> the US from your PC now! Get great low rates on international calls!
> http://click.egroups.com/1/10923/1/_/25703/_/977951447/
> --------------------------------------------------------------
> -------_->
>
> * Subscribe: coldfusion-howto-subscribe@egroups.com
> * Un-Subscribe: coldfusion-howto-unsubscribe@egroups.com
>
>
>
>
>


* Subscribe: coldfusion-howto-subscribe@egroups.com
* Un-Subscribe: coldfusion-howto-unsubscribe@egroups.com

Thanks for the tip.  The undocumented tags were interesting, but the one
that looked most promising yielded no results.  I applied the tag thusly:

<CFSET dis = CFUSION_GETODBCDSN()>

<CFOUTPUT>
<TABLE BORDER="1" CELLPADDING="2">
<TR>
   <TD>FIELD NAMES</TD>
   <TD>#dis.ColumnList#</TD>
</TR>
<TR>
   <TD>NO of RECORDS</TD>
   <TD>#dis.RecordCount#</TD>
</TR>
</TABLE>
</CFOUTPUT>

I tried this on several of my webservers (I collocate a fair number of
servers at a small farm) but the record count was always zero.  It did not
give me any errors, but did not yield any results, either.  Each of my NT
boxes hosts about 80 - 100 domains,  and approximately 40-50 system (ODBC)
DSN.  All of my clients are small to medium sized businesses, and my company
has a lot of MS Access experience, so we are not using SQL servers.

Any idea why the above scenario did not work?

Very Respectfully,

Michael E. Cummins




-----Original Message-----
From: Terence Chang [mailto:peanutlen@...]
Sent: Tuesday, January 02, 2001 6:11 PM
To: coldfusion-howto@egroups.com
Subject: Re: [coldfusion-howto] Listing available datasources and
tables/queries using cold fusion

--- "Michael E. Cummins"
<michael@...> wrote:
> Is there a command or technique to get an NT Server
> to list all of it's ODBC
> sources from cold fusion?

Check out Allaire's undocumented tags and function
http://www.allaire.com/cfdocs/Administering_ColdFusion_Server/10_Configuring
_Advanced_Security/admin1018.htm

>
> With that knowledge, is there a way to list all of
> the available
> tables/queries from a particular datasource in cold
> fusion?
>

Check out the system procedure sp_tables and
sp_columns in MSSQL or user_tables and
user_tab_columns in Oracle.

Terence Chang

Hi,

Please download the file which I had uploaded yesterday. It might
give you some information. The exact location of the file is :

http://www.egroups.com/files/coldfusion-howto/Security/CFsecurity%
2Eppt

Regards,
Rajesh Kumar

--- In coldfusion-howto@egroups.com, "nizam" <ajiexquote@m...> wrote:
> Hi,
> Now I develop a system using cold fusion and Microsoft SQL Server
for the
> database. My question is:
> 1.    I don't want any unauthorized people access this system via
web. How
> can I make the password system is safe using cold fusion like
security in
> Java. I don't want any hackers can hack the password in the
database.Is
> there any solution?
> 2.    Other people can access the coding if they using cold fusion
studio
> if
> they know the IP address of my server and the password. Is there
any other
> way for me to prevent this problem from happen?Or I can setting
something
> in
> Cold Fusion Server to prevent this from happen...Thanks for help
>
> Thank you

Hi,
Now I develop a system using cold fusion and Microsoft SQL Server for the
database. My question is:
1.    I don't want any unauthorized people access this system via web. How
can I make the password system is safe using cold fusion like security in
Java. I don't want any hackers can hack the password in the database.Is
there any solution?
2.    Other people can access the coding if they using cold fusion studio
if
they know the IP address of my server and the password. Is there any other
way for me to prevent this problem from happen?Or I can setting something
in
Cold Fusion Server to prevent this from happen...Thanks for help

Thank you

--- "Michael E. Cummins"
<michael@...> wrote:
> Is there a command or technique to get an NT Server
> to list all of it's ODBC
> sources from cold fusion?
Check out Allaire's undocumented tags and function
http://www.allaire.com/cfdocs/Administering_ColdFusion_Server/10_Configuring_Adv\
anced_Security/admin1018.htm

>
> With that knowledge, is there a way to list all of
> the available
> tables/queries from a particular datasource in cold
> fusion?
>
Check out the system procedure sp_tables and
sp_columns in MSSQL or user_tables and
user_tab_columns in Oracle.

Terence Chang

__________________________________________________
Do You Yahoo!?
Yahoo! Photos - Share your holiday photos online!
http://photos.yahoo.com/

Is there a command or technique to get an NT Server to list all of it's ODBC
sources from cold fusion?

With that knowledge, is there a way to list all of the available
tables/queries from a particular datasource in cold fusion?

I know that with a datasource and a table, I can list all of the available
fields...


Thank you for your assistance.

Very Respectfully,

Michael E. Cummins

Hello,

This email message is a notification to let you know that
a file has been uploaded to the Files area of the coldfusion-howto
group.

   File        : /Security/CFsecurity.ppt
   Uploaded by : rknewsletters@...
   Description : Cold Fusion Security Guide

You can access this file at the URL

http://www.egroups.com/files/coldfusion-howto/Security/CFsecurity%2Eppt

To learn more about eGroups file sharing, please visit

http://www.egroups.com/help/files.html


Regards,

rknewsletters@...

Enhance your skills, stay competitive and make more money by earning
your certification. There are a few sites which provide free
certification. Just register with them and take a exam. today.
Following sites are providing free certification in ColdFusion:

http://www.brainbench.com
http://www.skilldrill.com
http://www.ecertifications.com

You may also would like to visit http://www.cfcertification.com for
practice. It has good database of CF related questions.

If you know any other site which is also related to this, please let
me know.

Regards,
Rajesh Kumar
Moderator