> This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.
--MS_Mac_OE_3055513392_1746998_MIME_Part
Content-type: text/plain; charset="US-ASCII"
Content-transfer-encoding: 7bit
Yes. I use UltraDev everyday, in fact I use it so much I have now my
routine pretty well down packed.
UltraDev does have a lot of good features but it depends on how you work
that will dictate it's value, here's my process...
I develop using SQL 7 as my DB so all of my SELECTS, INSERTS and UPDATES are
written as stored procedures, not quite the Fusebox philosophy, but gives
you the ability to do all sorts of fancy stuff at the database level.
Returning @@IDENTITY, using sql GETDATE() etc.
I use Visual InterDev to create all my stored procedures, hence my database
is managed in it's own project. Handy because you can tweak any aspect of
all queries in your entire site. VID also makes life easy when making many
table joins in a query (drag and drop).
I create my site folders & files using UltraDev and also create a project in
CF Studio that points at the same directory.
I set the site language to CFML in UltraDev. There are two database
connections to define - RunTime and DesignTime, for the RunTime set to an
application variable eg #database# or #request.maindsn# Set the DesignTime
connection however you like so long as it gets to the database. Personally I
use ADO ODBC datasource and select the DSN.
Whew nearly there, their is a method in my madness...I hope :)
Because I have written almost all queries as stored procedures, for all of
your qry files open them in UltraDev. Go to Window > Server Behaviours,
click the + drop down and insert a Stored Procedure. UltraDev will bring
back all parameters and outputs of the procedure and write the complete CFML
code for you. You will rarely get a query page wrong. You can also specify
default values (in fact it forces you to) for all parameters. Handy for
those checkboxes, that if left unchecked are not available at all and do not
politely pass you a zero.
Handy side affect of this process...
Making the dsp files is quick and painless work in UltraDev. It doesn't mind
if there is no header and footer ie no <body></body> etc as these are in
your dsp_header and dsp_footer files. UltraDev is a good WYSWIG editor.
Traps...
Since the header file is separate if you go crazy with JavaScript this will
end up in the dsp file and not in the header. I keep it to a minimum and put
these functions in the dsp_header. I use CFFORM elements for all client side
validation. Unfortunate side affect is that when you open a page in UltraDev
and it encounters say a button that uses a JavaScript function not present
in the file it pops an error. Maybe I can just leave UltraDev JavaScript
functions in the dsp file?
You can flip back and forth between CF Studio and UltraDev, I do all day
long. But as we all know it sometimes messes with code. It is rare though
and you soon learn that it's not a good idea to pick up a table enclosed in
a IF ELSE statement and drag it somewhere, then wonder where the IF or even
the <output> code went.
Tips...
Can be handy to have a code maker file in the project, something like
tmp_codeMaker.cfm open it up point at a stored procedure then copy the CF
code generated, lazy way to make <cfstoredproc> code.
Pros...
Good separation of query data access logic from the rest of the code, make
the cf calling code once and use it anywhere in the project, like wise you
only write the query once because that's in the database. Yes even drop
downs, you never know when you need to change the order by. Fusebox does
this anyway, it's just that my statements are in the DB and my queries are
managed in a Visual Studio project. The qry file only contains a
<cfstoredproc> and it's associated parameters, unless of course if you are
building dynamic sql statements.
Fast. My cf code for qry and act files writes itself by using the Store
Procedure server behaviour in UltraDev, saves on a lot of boring and error
prone sql writing. This is the number one benefit for me and is the sole
reason I work this way. When you have got this mastered you'll churn out sql
code so uniform that when you edit a record, forget to change the POST
destination of the FORM, you'll end up inserting a new record instead of an
updating. Why? because you copied and pasted the insert form to make the
edit page. Now that's reuse :)
Life for me is data in > data out so this process works well.
Your DBA and database designer can help you out a lot, you create what you
want and the refinement can be left to another person.
Cons...
You have to know how to use three applications well - CF Studio, UltraDev
and Visual Studio. You'll be jumping between all of them.
A bit of SQL 7 knowledge certainly doesn't hurt, beg borrow or steal some
from a DBA
Use lots of SQL 7 tricks and you'll be tied to it, Same argument goes for
Oracle as well. This is one area where what I do and the Fusebox
architecture differs.
Malcolm
--
Malcolm Barclay
Director / E-commerce Architect
Rocket Company Pty Ltd
ACN 093 815 671 | ABN 13 093 815 671
Melbourne
Australia
Ph +61 3 9326 3793
Cell +61 (0410) 695 762
e-mail: [EMAIL PROTECTED]
web: http://www.rocketcompany.com
From: "John Foulds" <[EMAIL PROTECTED]>
Reply-To: [EMAIL PROTECTED]
Date: Wed, 27 Sep 2000 00:44:10 -0400
To: Fusebox <[EMAIL PROTECTED]>
Subject: Ultradev
This is a multi-part message in MIME format.
------=_NextPart_000_005C_01C0281C.0CE678C0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Has anyone spent any time with it?
When it first came out, I was enamored with it's sexy cross-scripting =
features, but found it really a pain to tinker with outside of it's =
standard behaviours.
It has some great tools though (ie. site tools) and now I am really =
curious if any Fuseboxers have had any experiences, takes on it, etc.
John Foulds
Ottawa, Canada
------=_NextPart_000_005C_01C0281C.0CE678C0
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; =
charset=3Diso-8859-1">
<META content=3D"MSHTML 5.50.4308.2900" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT size=3D2>Has anyone spent any time with it?</FONT></DIV>
<DIV><FONT size=3D2></FONT> </DIV>
<DIV><FONT size=3D2>When it first came out, I was enamored with it's =
sexy=20
cross-scripting features, but found it really a pain to tinker with =
outside of=20
it's standard behaviours.</FONT></DIV>
<DIV><FONT size=3D2></FONT> </DIV>
<DIV><FONT size=3D2>It has some great tools though (ie. site tools) and=20
n</FONT><FONT size=3D2>ow I am really curious if any Fuseboxers have had =
any=20
experiences, takes on it, etc.</FONT></DIV>
<DIV><FONT size=3D2></FONT> </DIV>
<DIV><FONT size=3D2>John Foulds</FONT></DIV>
<DIV><FONT size=3D2>Ottawa, Canada</FONT></DIV></BODY></HTML>
------=_NextPart_000_005C_01C0281C.0CE678C0--
----------------------------------------------------------------------------
--
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/fusebox or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
--MS_Mac_OE_3055513392_1746998_MIME_Part
Content-type: text/html; charset="US-ASCII"
Content-transfer-encoding: quoted-printable
<HTML>
<HEAD>
<TITLE>Re: Ultradev</TITLE>
</HEAD>
<BODY>
Yes. I use UltraDev everyday, in fact I use it so much I have now my =
routine pretty well down packed.<BR>
<BR>
UltraDev does have a lot of good features but it depends on how you work th=
at will dictate it's value, here's my process...<BR>
<BR>
<UL><LI>I develop using SQL 7 as my DB so all of my SELECTS, INSERTS and UP=
DATES are written as stored procedures, not quite the Fusebox philosophy, bu=
t gives you the ability to do all sorts of fancy stuff at the database level=
. Returning @@IDENTITY, using sql GETDATE() etc.<BR>
</UL><BR>
<UL><LI>I use Visual InterDev to create all my stored procedures, hence my =
database is managed in it's own project. Handy because you can tweak any asp=
ect of all queries in your entire site. VID also makes life easy when making=
many table joins in a query (drag and drop).<BR>
</UL><BR>
<UL><LI>I create my site folders & files using UltraDev and also create=
a project in CF Studio that points at the same directory.<BR>
</UL><BR>
<UL><LI>I set the site language to CFML in UltraDev. There are two database=
connections to define - RunTime and DesignTime, for the RunTime set to an a=
pplication variable eg #database# or #request.maindsn# Set the DesignTime co=
nnection however you like so long as it gets to the database. Personally I u=
se ADO ODBC datasource and select the DSN.<BR>
</UL><BR>
Whew nearly there, their is a method in my madness...I hope :)<BR>
<BR>
<UL><LI>Because I have written almost all queries as stored procedures, for=
all of your qry files open them in UltraDev. Go to Window > Server Behav=
iours, click the + drop down and insert a Stored Procedure. UltraDev will br=
ing back all parameters and outputs of the procedure and write the complete =
CFML code for you. You will rarely get a query page wrong. You can also spec=
ify default values (in fact it forces you to) for all parameters. Handy for =
those checkboxes, that if left unchecked are not available at all and do not=
politely pass you a zero.<BR>
</UL><BR>
Handy side affect of this process...<BR>
<BR>
<UL><LI>Making the dsp files is quick and painless work in UltraDev. It doe=
sn't mind if there is no header and footer ie no <body></body> e=
tc as these are in your dsp_header and dsp_footer files. UltraDev is a good =
WYSWIG editor.<BR>
</UL><BR>
Traps...<BR>
<BR>
<UL><LI>Since the header file is separate if you go crazy with JavaScript t=
his will end up in the dsp file and not in the header. I keep it to a minimu=
m and put these functions in the dsp_header. I use CFFORM elements for all c=
lient side validation. Unfortunate side affect is that when you open a page =
in UltraDev and it encounters say a button that uses a JavaScript function n=
ot present in the file it pops an error. Maybe I can just leave UltraDev Jav=
aScript functions in the dsp file?<BR>
</UL><BR>
<UL><LI>You can flip back and forth between CF Studio and UltraDev, I do al=
l day long. But as we all know it sometimes messes with code. It is rare tho=
ugh and you soon learn that it's not a good idea to pick up a table enclosed=
in a IF ELSE statement and drag it somewhere, then wonder where the IF or e=
ven the <output> code went.<BR>
</UL><BR>
Tips...<BR>
<BR>
<UL><LI>Can be handy to have a code maker file in the project, something li=
ke tmp_codeMaker.cfm open it up point at a stored procedure then copy the CF=
code generated, lazy way to make <cfstoredproc> code.<BR>
</UL><BR>
Pros...<BR>
<BR>
<UL><LI>Good separation of query data access logic from the rest of the cod=
e, make the cf calling code once and use it anywhere in the project, like wi=
se you only write the query <U>once</U> because that's in the database. Yes =
even drop downs, you never know when you need to change the order by. Fusebo=
x does this anyway, it's just that my statements are in the DB and my querie=
s are managed in a Visual Studio project. The qry file only contains a <c=
fstoredproc> and it's associated parameters, unless of course if you are =
building dynamic sql statements.<BR>
</UL><BR>
<UL><LI>Fast. My cf code for qry and act files writes itself by using the S=
tore Procedure server behaviour in UltraDev, saves on a lot of boring and er=
ror prone sql writing. This is the number one benefit for me and is the sole=
reason I work this way. When you have got this mastered you'll churn out sq=
l code so uniform that when you edit a record, forget to change the POST des=
tination of the FORM, you'll end up inserting a new record instead of an upd=
ating. Why? because you copied and pasted the insert form to make the edit p=
age. Now that's reuse :)<BR>
</UL><BR>
<UL><LI>Life for me is data in > data out so this process works well. <B=
R>
</UL><BR>
<UL><LI>Your DBA and database designer can help you out a lot, you create w=
hat you want and the refinement can be left to another person.<BR>
</UL><BR>
Cons...<BR>
<BR>
<UL><LI>You have to know how to use three applications well - CF Studio, Ul=
traDev and Visual Studio. You'll be jumping between all of them.<BR>
</UL><BR>
<UL><LI>A bit of SQL 7 knowledge certainly doesn't hurt, beg borrow or stea=
l some from a DBA<BR>
</UL><BR>
<UL><LI>Use lots of SQL 7 tricks and you'll be tied to it, Same argument go=
es for Oracle as well. This is one area where what I do and the Fusebox arch=
itecture differs.<BR>
</UL><BR>
Malcolm<BR>
<BR>
-- <BR>
Malcolm Barclay<BR>
Director / E-commerce Architect<BR>
Rocket Company Pty Ltd<BR>
ACN 093 815 671 | ABN 13 093 815 671<BR>
Melbourne<BR>
Australia<BR>
<BR>
Ph +61 3 9326 3793<BR>
Cell +61 (0410) 695 762<BR>
<BR>
e-mail: [EMAIL PROTECTED]<BR>
web: http://www.rocketcompany.com<BR>
<BLOCKQUOTE><BR>
<B>From: </B>"John Foulds" <[EMAIL PROTECTED]><BR>
<B>Reply-To: </B>[EMAIL PROTECTED]<BR>
<B>Date: </B>Wed, 27 Sep 2000 00:44:10 -0400<BR>
<B>To: </B>Fusebox <[EMAIL PROTECTED]><BR>
<B>Subject: </B>Ultradev<BR>
<BR>
</BLOCKQUOTE><BR>
<BLOCKQUOTE><TT>This is a multi-part message in MIME format.<BR>
<BR>
------=3D_NextPart_000_005C_01C0281C.0CE678C0<BR>
Content-Type: text/plain;<BR>
charset=3D"iso-8859-1"<BR>
Content-Transfer-Encoding: quoted-printable<BR>
<BR>
Has anyone spent any time with it?<BR>
<BR>
When it first came out, I was enamored with it's sexy cross-scripting =3D<BR>
features, but found it really a pain to tinker with outside of it's =3D<BR>
standard behaviours.<BR>
<BR>
It has some great tools though (ie. site tools) and now I am really =3D<BR>
curious if any Fuseboxers have had any experiences, takes on it, etc.<BR>
<BR>
John Foulds<BR>
Ottawa, Canada<BR>
<BR>
------=3D_NextPart_000_005C_01C0281C.0CE678C0<BR>
Content-Type: text/html;<BR>
charset=3D"iso-8859-1"<BR>
Content-Transfer-Encoding: quoted-printable<BR>
<BR>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"&=
gt;<BR>
<HTML><HEAD><BR>
<META http-equiv=3D3DContent-Type content=3D3D"text/html; =3D<BR>
charset=3D3Diso-8859-1"><BR>
<META content=3D3D"MSHTML 5.50.4308.2900" name=3D3DGENERATOR><B=
R>
<STYLE></STYLE><BR>
</HEAD><BR>
<BODY bgColor=3D3D#ffffff><BR>
<DIV><FONT size=3D3D2>Has anyone spent any time with it?</FONT=
></DIV><BR>
<DIV><FONT size=3D3D2></FONT>&nbsp;</DIV><BR>
<DIV><FONT size=3D3D2>When it first came out, I was enamored with=
it's =3D<BR>
sexy=3D20<BR>
cross-scripting features, but found it really a pain to tinker with =3D<BR>
outside of=3D20<BR>
it's standard behaviours.</FONT></DIV><BR>
<DIV><FONT size=3D3D2></FONT>&nbsp;</DIV><BR>
<DIV><FONT size=3D3D2>It has some great tools though (ie. site to=
ols) and=3D20<BR>
n</FONT><FONT size=3D3D2>ow I am really curious if any Fuseboxers=
have had =3D<BR>
any=3D20<BR>
experiences, takes on it, etc.</FONT></DIV><BR>
<DIV><FONT size=3D3D2></FONT>&nbsp;</DIV><BR>
<DIV><FONT size=3D3D2>John Foulds</FONT></DIV><BR>
<DIV><FONT size=3D3D2>Ottawa, Canada</FONT></DIV><=
/BODY></HTML><BR>
<BR>
------=3D_NextPart_000_005C_01C0281C.0CE678C0--<BR>
<BR>
---------------------------------------------------------------------------=
---<BR>
To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=3Dlists&a=
mp;body=3Dlists/fusebox or send a message to [EMAIL PROTECTED]=
with 'unsubscribe' in the body.<BR>
</TT></BLOCKQUOTE><TT><BR>
</TT>
</BODY>
</HTML>
--MS_Mac_OE_3055513392_1746998_MIME_Part--
------------------------------------------------------------------------------
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/fusebox or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
