Re: Looking for a Web Based ActiveX Treeview

2001-06-08 Thread Planet CF

If it works with VB/VC++ then you can make it work
thru JavaScript.

Atleast I could get the Protoview (Infragistics)
treeview to work 'quite well' for what I wanted to do.

www.infragistics.com (I am not canvassing for them...
just that I happened to work on it)

Kedar

--- Sutton Yamanashi <[EMAIL PROTECTED]>
wrote:
> Greetings CF-ers!
> 
> I am looking for an ActiveX Treeview that I can drop
> into a CF app that
> allows both checkboxes and radio buttons within the
> same tree.  Very similar
> to the tree on this page:
> 
> http://www.softelvdm.com/treeocx_ss.html
> 
> This tree is only avaiable to VB and Visual C++
> apps.  I need one that is
> web based.
> 
> Alternatively, is there anyway to do this with a
> CFTREE or possibly a
> customtag?
> 
> Any thoughts or past experiences would be greatly
> appreciated.
> 
> Thanks,
> Sutton
> 
> 
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



CF_MAGIC tag!!!!

2001-06-04 Thread Planet CF

Hi All,
I faced a very strange coding experience. I have a tag
with a single line comment in it. There is absolutely
no code inside it. So essentially it is an empty tag.
I call this the magic tag.

On my current project, I have a custom tag that builds
an HTML table dynamically based on a query. And this
tag has a lot of other business logic code that is
being called. It used to take 20 seconds (yes! 20
seconds) to build the table. I call this the snail
tag.

I wrapped all the code in the snail tag using the
magic tag. So the snail tag looks like this




all the business logic and the loop around the query
to build the dynamic HTML table




The time taken reduced to less than 2 seconds (yes!
less than 2 seconds). Now you know why I called is the
magic tag!!!

How does this happen?  Does anyone have an
explanation?

Thanks
Kedar Desai
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Unable to create client tables

2001-04-02 Thread Planet CF

Hi All,
I am unable to set up the CF server to use a Sybase
database as storage for the client variables. The
message that I get says, 'Unknown database - Unable to
create client tables'.

I am using sybase 11.

Thanks
Kedar
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



CFX problem: Debug or Release build

2001-02-23 Thread Planet CF

Hi,
I wrote this CFX for deleting rows from a query. My CF
version was very slow when the number of records were
large.

The CFX tag works fine if the DLL is from the "win32
debug" build. However if I take a 'Win32 Release"
build, I get an error if the number of rows in the
query are greater than 999. For 999 rows or less it
works fine.

Does anyone know which build we should be using.
Release or Debug.. I would beleive it to be the
'Release' build... but that one throws an error for
row count > 999

Kedar
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Help!! Re: Follow up on the WDDX Recordset Sort problem

2001-02-23 Thread Planet CF

Hi All,
I am sending this again as I need a solution.

I would greatly appreciate if someone can help me out.

And I had attached some code for reference. It did not
seem to have gone thru the last time... am trying
again

Kedar Desai
Differential Technologies

--- Planet CF <[EMAIL PROTECTED]> wrote:
> Hi,
> This is a follow up to my earlier mail on the
> problem
> that I have been having after using the WDDX
> extension
> from WDDX.org
> 
> For all those interested in seeing the problem that
> comes with CF see the attached code.
> 
> Extract the four files into a directory
> 
> 1. Run the GetEmpDtls.cfm file.It shows the empid's
> 2. Click 'OK'.
> 3. The javascript alert shows the WDDX recordset.
> Observe the new column 'preserveFieldCase' (top few
> lines)
> 4. The records are infact sorted
> 5. Now clikc OK again.
> 6. Again you see the javascript msg with one more
> 'preservefieldcase'
> 7. And then the CF error
> 
> Hope someone has a solution
> 
> Kedar Desai
> Differential Technologies
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Follow up on the WDDX Recordset Sort problem

2001-02-22 Thread Planet CF

Hi,
This is a follow up to my earlier mail on the problem
that I have been having after using the WDDX extension
from WDDX.org

For all those interested in seeing the problem that
comes with CF see the attached code.

Extract the four files into a directory

1. Run the GetEmpDtls.cfm file.It shows the empid's
2. Click 'OK'.
3. The javascript alert shows the WDDX recordset.
Observe the new column 'preserveFieldCase' (top few
lines)
4. The records are infact sorted
5. Now clikc OK again.
6. Again you see the javascript msg with one more
'preservefieldcase'
7. And then the CF error

Hope someone has a solution

Kedar Desai
Differential Technologies
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



WDDXRecordSet Sorting

2001-02-22 Thread Planet CF

Hi,
I am using the 'WddxRecordset Extensions' available
with the SDK from www.wddx.org. In the extensions
there is a method for sorting the WDDXRecordSet. It
sorts the recordset by the column you specify, or
using a custom sort function that you supply in a
custom JavaScript object.

Now here is something that the 'sort' method does. It
adds a new column to the sorted data, called
'preserveFieldCase'. If you sort in a loop, another
column with the same name is added. So now there are
multiple columns with the same name, namely
'preserveFieldCase'. 

Below is the serialized version of the WDDXRecordSet
after one sort. 

VR0009VR0008IINo new civil actions to be
processed exist for the specified case
type.The selected case does not have
an image.1999-7-26T0:0:0-5:02000-1-4T0:0:0-5:0

Here is the serialized version after the second sort.
See the duplicate column name, namely
'preserveFieldCase'

VR0009VR0008IINo new civil actions to be
processed exist for the specified case
type.The selected case does not have
an image.1999-7-26T0:0:0-5:02000-1-4T0:0:0-5:0

This is not mentioned in the documentation. Also
another point to note is that this column is not added
if the WDDXRecordSet has only one row. The above
example has two rows.

Because of these columns that get added to the sorted
recordset, the CFCFML2WDDX tag throws an error...
*
Error Diagnostic Information
unknown exception condition
TagCFWddx::doCFML2WddxStringTagCFWddx::execute
*

This error is thrown because the WDDX2CFML conversion
was not correct.


Is anyone out there who has done this before or can
give me a solution to this problem?

Thanks in advance

Kedar Desai
Differential Technologies
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



CFX and query manipulation

2000-12-18 Thread Planet CF

Hi all,

Is it true that a CFX tag can access only one query
from the calling template? (Page 177 of Ben Forta's
'Advanced ColdFusion' book) The book further goes on
to say that it is impossible for a CFX tag to access
or manipulate the contents of more then one query
result set from the calling template.

Does it hold good for CF4.5? Do CFXJ's help?

Kedar Desai
Differential Technologies
Fairfax, VA
=
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



CF bug?? Re: Mappinf on Cf server

2000-09-29 Thread Planet CF

Just an observation on mapping:

If you want to map
C:\Inetpub\wwwroot\app\Menu&Navigation
to
Menu&Nav

CF will allow you to do it the first time. But just
incase you need to change your mapping name, then you
cannot edit it from CFAdmin. You have to go to the
registry to edit it.

CFAdmin will show the mapping as 'Menu' and not
'Menu&Nav'

Is this a CF bug? has anyone else come across this
problem? I am running 4.5

Kedar Desai
Differential Technologies
Fairfax, VA




--- Peter Theobald <[EMAIL PROTECTED]> wrote:
> Yes, if you define the mapping: "/lib" =
> "/home/httpd/project1/cffiles/"
> 
> Then in your Cold Fusion code you can do this:
> 
> 
> Instead of this:
> 
template="/home/httpd/project1/cffiles/commerce.cfm">
> 
> This works for cfinclude, and cfmodule.
> 
> Unfortunately, you can NOT define separate mapping
> for each virtual server, so if you have a
> development, testing, and production copy of your
> site on the same server you can't really use mapping
> because your code will reference "/lib" (or whatever
> you use) and all three of the sites will be pointed
> to the SAME directory :-(
> In this case, you are stuck with putting some code
> in Application.cfm to figure out what your root
> directory is (using "GetCurrentTemplatePath()" ) and
> stick in a variable such as #lib# and then using
> http://im.yahoo.com/
>
>--
> >Archives:
>
http://www.mail-archive.com/cf-talk@houseoffusion.com/
> >To Unsubscribe visit
>
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk
> or send a message to
> [EMAIL PROTECTED] with 'unsubscribe'
> in the body. 
> 
> 
>
---
> Peter Theobald, Chief Technology Officer
> LiquidStreaming http://www.liquidstreaming.com
> [EMAIL PROTECTED]
> Phone 1.212.545.1232 x204 Fax 1.212.679.8032
> 
>
--
> Archives:
>
http://www.mail-archive.com/cf-talk@houseoffusion.com/
> To Unsubscribe visit
>
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk
> or send a message to
> [EMAIL PROTECTED] with 'unsubscribe'
> in the body.


__
Do You Yahoo!?
Yahoo! Photos - 35mm Quality Prints, Now Get 15 Free!
http://photos.yahoo.com/
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



CFMODULE - Template attribute

2000-09-28 Thread Planet CF

Hi All,
Here are my observations on CFMODULE - TEMPLATE
attribute:

Assumption:
1. The directory structure is
C:\Inetpub\wwwroot\App\Indexroot of the application
C:\Inetpub\wwwroot\App\CommonFiles\ common files
folder
C:\Inetpub\wwwroot\App\BusinessRuleLogic\ logic for
business rules

2. The following mappings have been created in CF
Administrator
CommonFiles maps to
"C:\Inetpub\wwwroot\App\CommonFiles\"
BusinessRuleLogic maps to
"C:\Inetpub\wwwroot\App\BusinessRuleLogic\"

Process:
The main page: C:\Inetpub\wwwroot\App\Index\index.cfm 
makes a call to:
C:\Inetpub\wwwroot\App\CommonFiles\ValidateUser.cfm
which calls:
C:\Inetpub\wwwroot\App\BusinessRuleLogic\IsValidData.cfm

This call can be made as

Method 1: Mapping Approach: Uses the mapping as
defined in CFAdmin




or 
Method 2: DoubleDot Aproach: Does not use the mapping
defined in CFAdmin




A point to note here is that 'Method 2' does not refer
to the mapping. This means that even if the mapping
does not exist the call ('Method 2') will still work.


Question:
Is it ok to use the '..' (DoubleDot approach) in
method 2 for calling the templates?

The advantage is that take out the DoubleDot and the
mappings startworking.

Now, if you want to know the reason for using this
approach, read on.  but do let me know if using
the DoubleDot is fine.


(I am planning to use this method to help developers
of a large intranet application be able to test their
work independently of other developers and at the same
time use the same CF Server. In this application
end-user testing runs in parallel to the development
process, meaning that a developer writes a function,
then tests it at his end and later copies his work to
another folder. The end-users are testing the
application from this folder and not the developers
folder.

In short, the DoubleDot approach helps bcoz the
developer can test his code by putting in the dot-dot.
After testing is complete the DoubleDot is removed and
then the file is transferred to the end-user testing
directory. A better way of doing this is by defining a
hidden field or a request variable that stores the dot
and I have figured out an better way of doing it)

Kedar Desai
Technical Manager
Differential Technologies
Fairfax, VA

__
Do You Yahoo!?
Yahoo! Photos - 35mm Quality Prints, Now Get 15 Free!
http://photos.yahoo.com/
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



RE: Various scopes

2000-08-18 Thread Planet CF

Am replying to this one a bit late...

Notes:
1. A query result overwrites a local variable and vice versa, bcoz defining
a query is like defining a local variable.
2. One can refer to 'client' variables without the scope.

so the precedence is :
Local variables ( also Query Result)
CGI variables
File variables
URL variables
Form variables
Cookie variables
Client variables

The following variables need to be scoped, always:
Session variables
Application variables
Server variables
Request variables

Kedar Desai
Differential Technologies
Fairfax, VA

-Original Message-
From: Steve Martin [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, August 02, 2000 10:56 AM
To: [EMAIL PROTECTED]
Subject: RE: Various scopes


If you leave the prefix off variables then the variable scope precedence is
as follows:
Query result variables
Local variables
CGI variables
File variables
URL variables
Form variables
Cookie variables

(Straight out of the Fasttrack manual Unit 11  :-)

These are the only variables in which the precedence rules apply. All
attributes, session, application, client (and whatever's left) need to be
explicitly referenced by the appropriate prefix.

HTH

Steve


> -Original Message-
> From: Paul Johnston [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, August 02, 2000 15:16
> To: '[EMAIL PROTECTED]'
> Subject: Various scopes
>
>
> I am having trouble realising what all the scopes are and there precedence
> in processing.
>
> I know about the variables scope and the attributes scope and
> session scope
> etc but I have no idea about which gets processed first, and what some of
> the more obscure ones are used for.  I am sure there are others out there
> who would want this info too.
>
> Thanks
>
> Paul
> --
> 
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> To Unsubscribe visit
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf
_talk or send a message to [EMAIL PROTECTED] with
'unsubscribe' in the body.


--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.


_
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com

--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



RE: WDDX

2000-08-15 Thread Planet CF

I did not quite get the question but just a suggestion:

You could use ACTION="CFML2JS" to do the two steps in one.

Kedar Desai

-Original Message-
From: Roger Lim [mailto:[EMAIL PROTECTED]]
Sent: Monday, August 14, 2000 10:36 PM
To: [EMAIL PROTECTED]
Subject: WDDX


Hi guys,

I tried using  to pass CF variable into Javascript. However I
realised that I can only have one variable, is there any ways that I can
pass two CF variables into JS function?

Below are my codes:





Thanks,
roger


--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.


__
Do You Yahoo!?
Talk to your friends online with Yahoo! Messenger.
http://im.yahoo.com
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



Using TRIM

2000-08-14 Thread Planet CF

Hi All,
A 'Select' on a Sybase Database results in extra
spaces being added to the data being selected (mostly
spaces on the right). I really don't know as to why
this is happenning.

So what we do is use the TRIM function to get rid of
those spaces. Now this has become some kind of a
"xtra" in the application. Like... if somehow you
forget to TRIM, you end up in errors which are not
traceable to a specific code for a long time
kindof time consuming... and frustratiing too. 

There could be two solutions to this problem:
1. Find out the reason for the 'spaces' that are being
added and fix the problem at the root.

2. Assuming that the problem cannot be fixed and one
has to deal with TRIM, a better way of doing it (that
comes to my mind) would be to write a custom tag that
TRIM's all query data before sending it to the calling
page. Is there a custom tag on the gallery, that
already does this?

Any suggestions or comments are welcome.

Thanks
Kedar Desai
Differential Technologies
Fairfax, VA


__
Do You Yahoo!?
Yahoo! Mail – Free email you can access from anywhere!
http://mail.yahoo.com/
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



RE: Query Delete?

2000-08-11 Thread Planet CF

The permissions are in the database and trying to do
it at display time (I understand this as doing it
while displaying it on the browser) may not be the
best way to do it.

> Kedar Desai
> Differential Technologies
> Fairfax, VA

--- "Olive, Christopher M Mr NMR"
<[EMAIL PROTECTED]> wrote:
> why can't you handle that logic at display time? 
> check to see to what the
> user has permissions, and display accordingly?
> 
> Chris Olive,
> DOEHRS Website Administrator 
> 
> -Original Message-
> From: Planet CF [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, August 09, 2000 4:46 PM
> To: [EMAIL PROTECTED]
> Subject: RE: Query Delete?
> 
> 
> The need for a QueryDeleteColumn or QueryDeleteRow
> arises in situations
> where one wants to manipulate the query due to
> various reasons.
> 
> One of them could something like applying security
> on the query. This means
> that the user does not priviledges to view all the
> rows/columns of the query
> (which is a join). In such a case you would want to
> delete data which is
> secure. One can say that incorporate that in the
> 'select' itself. However
> this cannot be done bcoz some users have override
> security priviledges,
> meaning that security does not apply for such users.
> 
> The bottomline is that, if there is a QueryAddColumn
> then why not a
> QueryDeleteColumn and also QueryDeleteRow.
> 
> Kedar Desai
> Differential Technologies
> Fairfax, VA
> 
> 
> -Original Message-
> From: David E. Crawford
> [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, August 08, 2000 10:39 AM
> To: [EMAIL PROTECTED]
> Subject: Re: Query Delete?
> 
> 
> This is a multi-part message in MIME format.
> 
> --=_NextPart_000_0175_01C00146.6E5DE680
> Content-Type: text/plain;
>   charset="Windows-1252"
> Content-Transfer-Encoding: quoted-printable
> 
> Query Delete?You could relatively easily do it using
> the QueryNew() =
> function and looping over. But what would be the
> point?  Just don't =
> selec the column in the first place.
> 
> DC
> 
>   - Original Message -=20
>   From: Planet CF=20
>   To: [EMAIL PROTECTED]=20
>   Sent: Tuesday, August 08, 2000 14:34
>   Subject: Query Delete?
> 
> 
>   Hi,=20
> 
>   Is there a custom tag somewhere out there, that=20
>   deletes a column from  a query?=20
> 
>   Thanks=20
>   Kedar Desai=20
>   Differential Technologies=20
>   Fairfax, VA=20
> 
> 
> 
>  
>
__=20
>   Do You Yahoo!?=20
>   Kick off your party with Yahoo! Invites.=20
>   http://invites.yahoo.com/=20
>   =
>
-=
> -=20
>   Archives:
>
http://www.mail-archive.com/cf-talk@houseoffusion.com/=20
>   To Unsubscribe visit =
>
http://www.houseoffusion.com/index.cfm?sidebar=3Dlists&body=3Dlists/cf_ta=
> lk or send a message to
> [EMAIL PROTECTED] with =
> 'unsubscribe' in the body.
> 
> 
> --=_NextPart_000_0175_01C00146.6E5DE680
> Content-Type: text/html;
>   charset="Windows-1252"
> Content-Transfer-Encoding: quoted-printable
> 
>  Transitional//EN">
> Query Delete?
>  =
> http-equiv=3DContent-Type>
>  name=3DGENERATOR>
> 
> 
> 
> You could
> relatively easily do it using =
> the=20
> QueryNew() function and looping over. But what would
> be the point?  =
> Just=20
> don't selec the column in the first
> place.
>  
> DC
>  
>  style=3D"BORDER-LEFT: #00 2px solid;
> MARGIN-LEFT: 5px; MARGIN-RIGHT: =
> 0px; PADDING-LEFT: 5px; PADDING-RIGHT: 0px">
>   - Original
> Message - 
>  style=3D"BACKGROUND: #e4e4e4; FONT: 10pt arial;
> font-color: =
> black">From:=20
>   mailto:[EMAIL PROTECTED]" =
> [EMAIL PROTECTED]>Planet CF=20
>   
>   To:href=3D"mailto:[EMAIL PROTECTED]"=20
>  
>
[EMAIL PROTECTED]>[EMAIL PROTECTED]
> 
>   Sent:
> Tuesday, August 08, 2000=20
> 14:34
>   Subject:
> Query Delete?
>   
>   Hi, 
>   Is there a custom tag somewhere
> out there, =
> that=20
>   deletes a column from  a
> query? 
>   Thanks  size=3D2>Kedar Desai =
>size=3D2>Differential Technologies
> Fairfax, =
> VA=20
>   
>   
size=3D2>__=20
>   Do You Yahoo!?  size=3D2>Kick off =
> your party=20
>   with Yahoo! Invites.  size=3D2>   href=3D"http://invites.yahoo.com/"=20
>  
> target=3D_blank>http://invites.

RE: Query Delete?

2000-08-09 Thread Planet CF

The need for a QueryDeleteColumn or QueryDeleteRow arises in situations
where one wants to manipulate the query due to various reasons.

One of them could something like applying security on the query. This means
that the user does not priviledges to view all the rows/columns of the query
(which is a join). In such a case you would want to delete data which is
secure. One can say that incorporate that in the 'select' itself. However
this cannot be done bcoz some users have override security priviledges,
meaning that security does not apply for such users.

The bottomline is that, if there is a QueryAddColumn then why not a
QueryDeleteColumn and also QueryDeleteRow.

Kedar Desai
Differential Technologies
Fairfax, VA


-Original Message-
From: David E. Crawford [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, August 08, 2000 10:39 AM
To: [EMAIL PROTECTED]
Subject: Re: Query Delete?


This is a multi-part message in MIME format.

--=_NextPart_000_0175_01C00146.6E5DE680
Content-Type: text/plain;
charset="Windows-1252"
Content-Transfer-Encoding: quoted-printable

Query Delete?You could relatively easily do it using the QueryNew() =
function and looping over. But what would be the point?  Just don't =
selec the column in the first place.

DC

  - Original Message -=20
  From: Planet CF=20
  To: [EMAIL PROTECTED]=20
  Sent: Tuesday, August 08, 2000 14:34
  Subject: Query Delete?


  Hi,=20

  Is there a custom tag somewhere out there, that=20
  deletes a column from  a query?=20

  Thanks=20
  Kedar Desai=20
  Differential Technologies=20
  Fairfax, VA=20



  __=20
  Do You Yahoo!?=20
  Kick off your party with Yahoo! Invites.=20
  http://invites.yahoo.com/=20
  =
-=
-=20
  Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/=20
  To Unsubscribe visit =
http://www.houseoffusion.com/index.cfm?sidebar=3Dlists&body=3Dlists/cf_ta=
lk or send a message to [EMAIL PROTECTED] with =
'unsubscribe' in the body.


--=_NextPart_000_0175_01C00146.6E5DE680
Content-Type: text/html;
charset="Windows-1252"
Content-Transfer-Encoding: quoted-printable


Query Delete?





You could relatively easily do it using =
the=20
QueryNew() function and looping over. But what would be the point?  =
Just=20
don't selec the column in the first place.
 
DC
 

  - Original Message - 
  From:=20
  mailto:[EMAIL PROTECTED]" =
[EMAIL PROTECTED]>Planet CF=20
  
  To: mailto:[EMAIL PROTECTED]"=20
  [EMAIL PROTECTED]>[EMAIL PROTECTED] 
  Sent: Tuesday, August 08, 2000=20
14:34
  Subject: Query Delete?
  
  Hi, 
  Is there a custom tag somewhere out there, =
that=20
  deletes a column from  a query? 
  Thanks Kedar Desai =
Differential Technologies Fairfax, =
VA=20
  
  __=20
  Do You Yahoo!? Kick off =
your party=20
  with Yahoo! Invites. http://invites.yahoo.com/"=20
  target=3D_blank>http://invites.yahoo.com/ =
--=20
  Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/"=20
  =
target=3D_blank>http://www.mail-archive.com/cf-talk@houseoffusion.com/=20
  To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=3Dlists&body=3D=
lists/cf_talk"=20
  =
target=3D_blank>http://www.houseoffusion.com/index.cfm?sidebar=3Dlists&am=
p;body=3Dlists/cf_talk=20
  or send a message to [EMAIL PROTECTED] with =
'unsubscribe' in=20
  the body.

--=_NextPart_000_0175_01C00146.6E5DE680--


--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.


_
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com

--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



Query Delete?

2000-08-08 Thread Planet CF

Hi,

Is there a custom tag somewhere out there, that
deletes a column from  a query?

Thanks
Kedar Desai
Differential Technologies
Fairfax, VA


__
Do You Yahoo!?
Kick off your party with Yahoo! Invites.
http://invites.yahoo.com/
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



The action page

2000-08-07 Thread Planet CF

Hi All,

What is the action page of a form, if the 'action'
attribute in the  tag is not specified?
i.e 
Some HTML tags...



>From my experimentation it was discovered that the
action page is the form page. This means that the same
page will be loaded again when the submit button is
clicked.

So now my question is, Who decides what the action
page is and how. I assume it should be the WebServer
and not the CFServer. So in that case, does the
Webserver use the URL to decide the action page or is
it some CGI variable or something in HTTP??


Thanks
Kedar Desai
Differential Technologies
Fairfax, VA



__
Do You Yahoo!?
Kick off your party with Yahoo! Invites.
http://invites.yahoo.com/
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



RE: The FORM structure

2000-08-07 Thread Planet CF

Solution is fine but my question is why do all other
structure operations work while StructCopy does not...

So I could well write a custom tag that would do what
StructCopy does using StuctUpdate or StructInsert as
the case may be.

Kedar

--- "Olive, Christopher M Mr NMR"
<[EMAIL PROTECTED]> wrote:
> why not copy the form structure to some local
> struct, modify that, and send
> THAT to the custom tag?
> 
> Chris Olive,
> DOEHRS Website Administrator 
> 
> -----Original Message-
> From: Planet CF [mailto:[EMAIL PROTECTED]]
> Sent: Friday, August 04, 2000 10:54 AM
> To: [EMAIL PROTECTED]
> Subject: The FORM structure
> 
> 
> Hi,
> FORM is a structure in Cold Fusion. All structure
> operations can be performed in the FORM structure,
> except for StructCopy. 
> 
> The following code:
> 
> 
> 
> 
> 
> 
> does not work
> 
> The exact error message is:
> "Cannot assign result to symbol FORM"
> 
> Why does it behave like this? One application of
> changing the FORM structure would be to use it
> directly in CFUPDATE, CFINSERT after modifying it.
> Though there are other solutions to this, I would
> prefer to change the FORM structure and then send it
> to mycustom tag.
> 
> Thanks and regards,
> Kedar Desai
> Differential Technologies
> Fairfax, VA
> 
> 
> 
> __
> Do You Yahoo!?
> Kick off your party with Yahoo! Invites.
> http://invites.yahoo.com/
>

> --
> Archives:
>
http://www.mail-archive.com/cf-talk@houseoffusion.com/
> To Unsubscribe visit
>
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk
> or
> send a message to [EMAIL PROTECTED]
> with 'unsubscribe' in
> the body.
>
--
> Archives:
>
http://www.mail-archive.com/cf-talk@houseoffusion.com/
> To Unsubscribe visit
>
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk
> or send a message to
> [EMAIL PROTECTED] with 'unsubscribe'
> in the body.


__
Do You Yahoo!?
Kick off your party with Yahoo! Invites.
http://invites.yahoo.com/
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



The FORM structure

2000-08-04 Thread Planet CF

Hi,
FORM is a structure in Cold Fusion. All structure
operations can be performed in the FORM structure,
except for StructCopy. 

The following code:






does not work

The exact error message is:
"Cannot assign result to symbol FORM"

Why does it behave like this? One application of
changing the FORM structure would be to use it
directly in CFUPDATE, CFINSERT after modifying it.
Though there are other solutions to this, I would
prefer to change the FORM structure and then send it
to mycustom tag.

Thanks and regards,
Kedar Desai
Differential Technologies
Fairfax, VA



__
Do You Yahoo!?
Kick off your party with Yahoo! Invites.
http://invites.yahoo.com/
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



RE: Commenting Text in Studio

2000-07-28 Thread Planet CF

CF has a 'Quick Bar' which is usually on the RH of the
CF Studio. (Ctrl+H) or from the Menu select View --->
Quick Bar

In the "Quick Bar", select the "CFML Basic" tab and
you will not only see the 'comment' but also
'cfoutput', '##' and many more. You could insert your
own by right clicking and selecting 'Customise'. Rest
is for you to explore.

Kedar Desai
Differential Technologies
Fairfax, VA


--- David Gassner <[EMAIL PROTECTED]> wrote:
> It's the 2nd button from the right on the CFML Basic
> toolbar.  Highlight the
> text you want to comment, then click the button.
> 
> > -Original Message-
> > From: Paige Chandler [mailto:[EMAIL PROTECTED]]
> > Sent: Thursday, July 27, 2000 10:24 PM
> > To: [EMAIL PROTECTED]
> > Subject: Commenting Text in Studio
> >
> >
> > This is a multi-part message in MIME format.
> >
> > --=_NextPart_000_0009_01BFF832.922450D0
> > Content-Type: text/plain;
> > charset="iso-8859-1"
> > Content-Transfer-Encoding: quoted-printable
> >
> > Hi All,
> >
> > I saw someone at the last sig click on an icon in
> the upper right corner =
> > (I believe) in Studio that automatically added the
>  to a block =
> > of text. I can't remember how he did that.
> >
> > I can't find reference to that in the books or
> Help. I would appreciate =
> > it if you could refresh my memory. TIA.
> >
> > Regards,
> >
> > Paige
> >
> > --=_NextPart_000_0009_01BFF832.922450D0
> > Content-Type: text/html;
> > charset="iso-8859-1"
> > Content-Transfer-Encoding: quoted-printable
> >
> >  Transitional//EN">
> > 
> >  content=3D"text/html; =
> > charset=3Diso-8859-1">
> >  name=3DGENERATOR>
> > 
> > 
> > 
> > Hi
> All,
> >  size=3D2> 
> > I saw someone at
> the last sig click on =
> > an icon in=20
> > the upper right corner (I believe) in Studio that
> automatically added =
> > the=20
> >  to a block of text. I can't
> remember how he did=20
> > that.
> >  size=3D2> 
> > I can't find
> reference to that in the =
> > books or=20
> > Help. I would appreciate it if you could refresh
> my memory. =
> > TIA.
> >  size=3D2> 
> >  size=3D2>Regards,
> >  size=3D2> 
> >  size=3D2>Paige
> >
> > --=_NextPart_000_0009_01BFF832.922450D0--
> >
> >
>
--
> > 
> > Archives:
>
http://www.mail-archive.com/cf-talk@houseoffusion.com/
> > To Unsubscribe visit
> >
>
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf
> _talk or send a message to
> [EMAIL PROTECTED] with
> 'unsubscribe' in the body.
> 
>
--
> Archives:
>
http://www.mail-archive.com/cf-talk@houseoffusion.com/
> To Unsubscribe visit
>
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk
> or send a message to
> [EMAIL PROTECTED] with 'unsubscribe'
> in the body.


__
Do You Yahoo!?
Kick off your party with Yahoo! Invites.
http://invites.yahoo.com/
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



SQL Success Return Codes

2000-07-13 Thread Planet CF

Hi All,
Here is question:


UPDATE EMPLOYEES
SET SALARY = 7
WHERE EMP_NAME = 'MEE'


Assuming the EMP_NAME was 'ME' instead of 'MEE', the
update will not take place. The Database return code
woud be 'zero rows updated'.

Is there a way to know whether the update was
successful? Like in the above SQL can we come to know
that the update did not actually take place.

Thanks and regards,
Planet CF
Differential Technologies
Fairfax, VA

__
Do You Yahoo!?
Get Yahoo! Mail – Free email you can access from anywhere!
http://mail.yahoo.com/
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



Getting return codes from Database

2000-07-12 Thread Planet CF

Hi All,
Here is question:


UPDATE EMPLOYEES
SET SALARY = 7
WHERE EMP_NAME = 'MEE'


Assuming the EMP_NAME was 'ME' instead of 'MEE', the
update will not take place. The Database return code
woud be 'zero rows updated'.

Is there a way to know whether the update was
successful? Like in the above SQL can we come to know
that the update did not actually take place.

Thanks and regards,
Planet CF
Differential Technologies
Fairfa, VA

__
Do You Yahoo!?
Get Yahoo! Mail – Free email you can access from anywhere!
http://mail.yahoo.com/
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



Is this a Bug? Problems with StructNew in CFParam

2000-07-11 Thread Planet CF

--0-1804289383-963344688=:6412
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline

Hi Friends,
Just joined this list and am posting my first
question:

In my application, forms are being called either
directly using URL or as custom tags through common
pages... meaning that I could directly post to a page
or could call the same page using CFModule.

Here is the question:
The input to the page is a structure when it is called
as a custom tag and when it is called directly there
is no input. So the need arises to default the input
to something like StructNew()...

However the following code is not working and gives
strange errors (I mean, really strange!!)



I have attached the errors as HTML files..

One error is:
**
Attributes.MyStruct=CFTempOnlyForSetVariableNeverUseThisNameInYourCFMLCode1223335654321
Cannot assign result to symbol Attributes.MyStruct
**

Another error is:
Error Diagnostic Information

Request canceled or ignored by serverServer busy or
unable to fulfill request. The server is unable to
fulfill your request due to extremely high traffic or
an unexpected internal error. Please attempt your
request again (if you are repeatedly unsuccessful you
should notify the site administrator). (Location Code:
26)


Is this a bug in CFML? Because if I have ArrayNew(1)
as default and type="array" everything works fine.

Thanks in advance

PlanetCF
Differential Technologies 
Fairfax, VA



__
Do You Yahoo!?
Get Yahoo! Mail – Free email you can access from anywhere!
http://mail.yahoo.com/
--0-1804289383-963344688=:6412
Content-Type: text/plain; name="Error Occurred While Processing Request.htm"
Content-Description: Error Occurred While Processing Request.htm
Content-Disposition: inline; filename="Error Occurred While Processing Request.htm"

Error
 Occurred While Processing RequestError Occurred While 
Processing Request Error Diagnostic 
InformationAn error has occurred while processing the expression:   
Attributes.MyStruct=CFTempOnlyForSetVariableNeverUseThisNameInYourCFMLCode1223335654321
 Error near line 1, column 1.Cannot assign result to symbol 
Attributes.MyStructThe error occurred while processing an element with a 
general identifier of (CFPARAM), occupying document position (1:1) to 
(1:74).Date/Time: 07/11/00 15:29:33Browser: Mozilla/4.0 (compatible; 
MSIE 5.0; Windows NT; DigExt)Remote Address: 
127.0.0.1Please inform the mailto:[EMAIL PROTECTED]">site administrator that this error has occurred (be 
sure to include the contents of this page in your message to the administrator).

--0-1804289383-963344688=:6412
Content-Type: text/plain; name="Error 403.htm"
Content-Description: Error 403.htm
Content-Disposition: inline; filename="Error 403.htm"



Error
 Occurred While Processing Request





















Error Occurred While Processing Request


  
  

  Error Diagnostic Information
  An error has occurred while processing the expression:   
Attributes.MyStruct=CFTempOnlyForSetVariableNeverUseThisNameInYourCFMLCode1223335654321

  
  
  Error near line 1, column 1.
  

  Cannot assign result to symbol Attributes.MyStruct
  
  
  The error occurred while processing an element with a general 
  identifier of (CFPARAM), occupying document position (1:1) to (1:74).
  
  Date/Time: 07/11/00 15:17:20Browser: Mozilla/4.0 (compatible; MSIE 
  5.0; Windows NT; DigExt)Remote Address: 127.0.0.1
  
Please inform the mailto:[EMAIL PROTECTED]">site administrator 
that this error has occurred (be sure to include the contents of this page in 
your message to the administrator).




--0-1804289383-963344688=:6412
Content-Type: text/html; name="Error.htm"
Content-Description: Error.htm
Content-Disposition: inline; filename="Error.htm"


ErrorError Occurred While Processing 
RequestError Diagnostic InformationRequest 
canceled or ignored by serverServer busy or unable to fulfill request. The server is 
unable to fulfill your request due to extremely high traffic or an unexpected internal 
error. Please attempt your request again (if you are repeatedly unsuccessful you 
should notify the site administrator). (Location Code: 26)
Please inform the mailto:[EMAIL PROTECTED]">site 
administrator that this error has occurred (be sure to include the contents of 
this page in your message to the administrator).
--0-1804289383-963344688=:6412--
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.