Hi,
Trying to create an aba export file that is compliant with the standard aba
format for electronic funds transfer
Does anyone have any knowledge of the structure / syntax of the header,
multiple records and footer lines that make up the file
Anyone who can assist me please email me at
Very nice, Duncan and Max. I have to admit I just had never noticed or heard
about this NULL attribute of CFQUERYPARAM. It does indeed seem to be just
the ticket. From doing some searching, I see that over time it's evolved
(some glitches have been fixed) so it really seems the perfect solution
Yes, you're right, Duncan. But to Andrew, a very important point need to be
made again: you're confusing query caching (caching the results of a SQL
SELECT statement) with query plan caching (what Duncan is describing).
CFQUERYPARAM affects query plan caching. That caching is entirely in the
Right, then as it seems, this all comes down to the point made some time
ago: if you use SELECT * in a statement using CFQUERYPARAM, you can expect
trouble if you add columns to the table. Among the places this is discussed
is here:
http://www.1pixelout.net/2004/06/16/cfqueryparam/
Hope that
Well, I know I just wrote my last note so you can't have seen it yet, but
I'll answer more directly this later question of yours, Andrew: there is no
connection between CFQUERYPARAM and the cached queries feature. Are you
saying you have some MM resource that suggests otherwise? That would be
When you say no flash or Ajax, are you saying you'd be open to DHTML? There
have long been CFML custom tags enabling this sort of thing, but they do all
rely on Javascript. Actually, Ajax is just a packaging of similar
HTML/Javascript/CSS functionality. If you don't want Ajax, then it seems you
Charlie,
No pushing of buttons going on, I was asking like a lemming because I
was wondering if there were other reasons that I did not know about. I
am aware of the larger amounts of data where unneccessary, but thats
about it.
Sometimes I find asking this way on a list questions like these
Charlie,
Cheers for the info, but I wasn't confusing anything. I was asking to begin
with.
And with select * from when using cfqueryparam, I only am reporting what is
reported as a solution on the Adobe livedocs.
Gosh:-)
Andrew Scott
Senior Coldfusion Developer
Aegeon Pty. Ltd.
Charlie,
The link is
http://livedocs.adobe.com/coldfusion/6.1/htmldocs/tags-b20.htm
The quote on the page is :
I checked with one of our technical people and this is what he said:
*
Most database (including SQLServer) presume that the database structure does
not change between re-uses of
I am hosting a CF7 site I developed.
www.hostingfuse.com/
The hosting had to be as cheap as possible and server usage is not
expected to shoot through the roof anytime soon. So far, I think it's
a sweat deal for the client. Support sometimes takes a bit long to
reply - but otherwise it seems to
Most database (including SQLServer) presume that the database structure does
not change between re-uses of parameterized queries.
What a strange presumption for them to make! Sure, table-schema
updates are rare compared to table-queries, but it's not like the DB
doesn't *know* when the table
Oracle does behave like this - actually to the point where you can't add new
tables and then run parametrised queries on them within the same session (I
believe it is session related).
Databases weren't designed to dynamically updated at runtime, and never have
been - so you will end up hitting
Databases weren't designed to dynamically updated at runtime, and never have
been - so you will end up hitting brick walls there.
Can you explain to me what you mean by runtime, in the context of a
DB engine? In such a way that distinguishes between me using CF as a
DB client or using Query
I am a SELECT * user.
(In my defence, I'm self-taught and didn't know any better until now)
My question... is there a trick or tip or tool that you guys use to save
typing in the name of every field that you're after? If you're populating
a big long form, it's a real pain to type every field
Hi Tom,
If you're doing SELECT * for a single record then don't worry about it - the
overhead is minuscule. The real problems with SELECT * happen when you are
running a query that will return multiple (hundreds/thousands of) records and
the overhead can become enormous. And if you are doing
Well,
In my defence I use select * from still too, but I do not use cfqueryparam
in my cfcs either so it is not an issue for me.
But having said that, I am now using ORM's mainly Reactor, Sorry Mark
haven't got the time to look at your Transfer framework just yet (still
using reactor in
Sigh, and I mean, *BIG sigh*. :-)
Andrew, what about this set of comments argues in favor of a connection
between CFQUERYPARAM and the cached queries feature, which you referred to
in your earlier note? Are you referring to the 2. Change [Max Pooled
Statements] in Datasource Advanced Settings to
*sigh*
Well Charlie, when you pushed for time and you reply to something you can't
always think of the top of your head. In this case I was trying to picture
the settings in the administrator.
Now in my defence, until Duncan came out and said it. It was still not very
clear on how he was doing
Tom, what editor do you use? Nearly all of them (CF Studio, HomeSite+,
Dreamweaver, and CFEclipse) offer the RDS feature, which would allow you to
view all the tables and their columns for all datasources defined in your CF
admin. These offer either a list of column names you can drag and drop
+1 for ORMs.
Or at the very least, wrap your data access in a bean or something, so
at least you only write the query once.
Andrew Scott wrote:
Well,
In my defence I use select * from still too, but I do not use
cfqueryparam in my cfcs either so it is not an issue for me.
But having
Thanks Charlie,
I'm alternating between Dreamweaver and Eclipse at the moment, depending on
the project. Since my original post, I found a button in MySQL Manager (
http://www.mysqlmanager.com/) that copies all field names to clipboard.
Reasonably easy.
Cheers,
Tom 12-step MacKean
On 3/6/07,
Tom,
If you are using CFEclipse can I suggest you look at a tool called SQL
Explorer, that will allow you to create your query and copy and paste that
into your code, also very good because it is a JDBC aware so it will connect
to any know DB using JDBC drivers.
Andrew Scott
Senior
I remember there's a website that provides a service for previewing
your website in all versions of all browsers for all OSes, but I don't
who it was.
Does anyone know of one?
Chris
--
Chris Velevitch
Manager - Sydney Flash Platform Developers Group
m: 0415 469 095
www.flashdev.org.au
http://www.browsercam.com/
Cheers
Matt
Matt Freer Senior Developer
Gruden - Design | Development | Implementation
t +61 2 9299 9462 f +61 2 9299 9463 www.gruden.com
-Original Message-
From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On
Behalf Of Chris Velevitch
If using Eclipse I've found quantumdb to also be good.
http://quantum.sourceforge.net
Although it does require you to make sure that the Eclipse GEF plugin
is installed, and I've been having trouble with the latest version.
com.quantum.feature_3.0.1.bin.dist.zip seems to work o.k.
Cheers
25 matches
Mail list logo
