[ACFUG Discuss] Data Aquistion App

2006-10-04 Thread Robert Reil
During Ray Camden's demonstration of Canvas Wiki it occurred to me that that may be a useful app if it was tweaked. Heres what I need to happen. We need to aquire proprietary information. This info will not be for public viewing. I will need lots of year/make/model specific

[ACFUG Discuss] CFMX7 Web App Const Kit Book Study Group

2006-10-04 Thread Robert Reil
Two weeks from now on Tuesday Daniel and I will begin going through the CFMX7 Web App Construction Kit book by Forta, and Camden. If anyone is interested in meeting at 6:30pm in Kennesaw to go through this book please contact me for further info. Robert Reil www.motorcyclecarbs.com

RE: Re: Re: [ACFUG Discuss] css - a little off topic

2006-10-04 Thread Dan Kaufman
The recent posts on this "CSS-a little off topic" thread re upgrading browsers was, I think, triggered by my comment/tip to Dusty to use Firefox as a development browser while coding his CSS style sheets. My reasoning for this was based on (sometimes painful) personal experience of having "styled a

Re: Re: Re: [ACFUG Discuss] css - a little off topic

2006-10-04 Thread Steven Ross
I didn't mean to insinuate that IE 7 is coming out so eveyone will upgrade... i was just making the point that if you intend to future proof your css build for the standard and work backwards because eventually the non compliant browsers will die off and (hopefully) the compliant ones will take ov

Re: [ACFUG Discuss] Search functions

2006-10-04 Thread Gerrey . Mary-Catherine
Yeah, that would be nice, but this is the gubbment.  Adding in hardware just isn't going to happen.  Especially not when they just have rolled out Northern Light. mcg Ben Johnson <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 10/04/2006 01:50 PM Please respond to discussion@acfug.org

Re: [ACFUG Discuss] Search functions

2006-10-04 Thread Ben Johnson
You might also want to check out the Google Mini, especially if you're going the file-on-server route.  I did not have fun with CF's Verity, nor Lindex (CFMX 6).  Both had poor admin interfaces, and did not provide results that our users trusted.  Also, neither one allowed for spidering, which seem

[ACFUG Discuss] Re: css - a little off topic

2006-10-04 Thread Rob Seebach
Hi Guys, I came across this in the blogs. A good heads up with the approach of IE 7 release. Preparing Your Site for Internet Explorer 7 Here's the scenario: one morning you open your email and your inbox is flooded with emails that your site isn't working properly. Maybe your text or ima

RE: [ACFUG Discuss] Issue with return from cfquery

2006-10-04 Thread Jeff Howard
What was causing the issue was setting the rowcount 1 and maintaining connections across client requests.  Apparently this set the rowcount to all queries called after this to have a rowcount of 1.   So access to the CF Admin was pretty critical to the resolution using the code as I originally wr

RE: [ACFUG Discuss] XML and CF question

2006-10-04 Thread Charlie Arehart
Douglas, while others may chime in with an exact answer, I want to point out that the best resource to get started with XML in CFML (in my opinion) is a 30-page guide by Nate Weiss. It was a chapter in the WACK book, if you have that also. The guide is available online in the Adobe XML CF De

RE: [ACFUG Discuss] Issue with return from cfquery

2006-10-04 Thread Charlie Arehart
Others have already clarified the issue with troubling issues with the approach you used to get the last inserted record. I realize it may have seemed logical to you. Just one of those "patterns" that you learn with time in CFML. We've all been there.   But don't leave us in suspense on the

[ACFUG Discuss] Re: XML and CF question

2006-10-04 Thread Douglas Knudsen
geesh, what a noob.  After recalling that I have Forta's Advanced CF7 book in my cube I 'parsed' the info out into me head.  Seems there's a bug in things though maybe.  If the below XML had its root node named 'xmlroot' then to get to the name is cake: myXML['xmlroot']['customer-rec']['name'].xmlt

RE: [ACFUG Discuss] XML and CF question

2006-10-04 Thread Kevin Hellriegel
XMLParse turns your xml into a nice structured array. You can get the customer's name using myXML.xml-root.customer-rec.name.xmltext. So your code would look like:   name:#myXML.xml-root.customer-rec.name.xmltext#   HTH   Kevin Hellriegel Capital Transportation Solutions http://www.shipwithct

[ACFUG Discuss] Search functions

2006-10-04 Thread Gerrey . Mary-Catherine
We are looking at either storing files on a server somewhere (and no "file server" anywhere, so they would have to be synched via PeerSync) or in the database as blobs (Oracle).  The fun part of this is that we want to put in a search functionality.  We are looking at CF's Verity (potentially Nort

RE: [ACFUG Discuss] Issue with return from cfquery

2006-10-04 Thread axunderwood
Also, as a follow up - the reason you're having the problem is this - you're doing a set rowcount 1 and cf is holding onto the connection.  That means all selects after that point are going to do only one row.  If you want to keep the code the way you currently have it, after your ORDER BY i

RE: [ACFUG Discuss] Issue with return from cfquery

2006-10-04 Thread Benjamin Bloodworth
Well SET ROWCOUNT 1 will make the queries stop processing after retrieving only one record.  With maintain connections set, the rowcount limit stays in effect for all queries.   A simpler approach is   INSERT INTO ATable(MyColumns) VALUES (MyValues)   SELECT SCOPE_IDENTITY() AS id  

Re: [ACFUG Discuss] Issue with return from cfquery

2006-10-04 Thread Douglas Knudsen
I'm no SQL Server master, but I'd think you just use the SELECT SCOPE_IDENTITY() as ID; to fetch the last used id.so, in one cfquery tag you'd haveINSERT INTO table (col1, col2)VALUES(val1, val2);SELECT SCOPE_IDENTITY() as ID;Then foo.id has your last inserted id. DK On 10/4/06, Jeff Howard <[EMAI

[ACFUG Discuss] XML and CF question

2006-10-04 Thread Douglas Knudsen
Ok, been awhile since I did this.  The E4X support in ActionScript 3 makes this cake by the way. Say I have a string of  XML that I stuff in a var        Pat Smythe 5551212   I parse it into a XML object thingy Now, how do I get to the customer name?  I am using xpath stuff to get at

RE: [ACFUG Discuss] Issue with return from cfquery

2006-10-04 Thread axunderwood
You should probably look into using scope_identity() rather than the method you use below...that may help you out a bit...   INSERT into blah() values() SELECT ID = SCOPE_IDENTITY()   Rowcount can cause some headaches... -Original Message-From: [EMAIL PROTECTED] [mailto

RE: [ACFUG Discuss] Issue with return from cfquery

2006-10-04 Thread Jeff Howard
So I got access to the CF Admin this morning and between that and Profiler I can see what is causing my issue and can resolve.  Thanks for everyone's help once again.  It was a comination of advice that got me to this point.   Now I was wondering if anyone could tell me why this issue is happenin

Re: Re: [ACFUG Discuss] css - a little off topic

2006-10-04 Thread Douglas Knudsen
*raises hand*  :)  we are also officially still on Office 97 too.  I'm actually sort of spoiled though, as we officially only support IE 6 on our intranet where I do all my work.  So I can sit in the stands and watch the CSS death matches. DKOn 10/4/06, allen <[EMAIL PROTECTED]> wrote: IE6 won't be

Re: Re: [ACFUG Discuss] css - a little off topic

2006-10-04 Thread Gerrey . Mary-Catherine
Well technically the EPA only supports IE 6, but lots of people around here use FF, but I live in the IT world over here.  But also they are big on pushing auto updates out.  And I would think that those that have autoupdates IE 7 would be pushed out (at least to XP users).  So a good chunk of you

Re: Re: [ACFUG Discuss] css - a little off topic

2006-10-04 Thread allen
IE6 won't be going anywhere for a long time - do you really think corporate america will upgrade the minute 7 is final?Who is running win2k in 2006? :)- Original Message From: Steven Ross <[EMAIL PROTECTED]>To: discussion@acfug.orgSent: Wednesday, October 4, 2006 8:55:55 AMSubject: Re: Re:

Re: Re: [ACFUG Discuss] css - a little off topic

2006-10-04 Thread Steven Ross
Yeah i follow this same track... easier for me to get it right (epecially since ie 6 will go away at some point) and support the standards then hack backwards to get IE compatibility. On 10/4/06, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: Yes, when it comes to CSS, IE stinks. You can write

Re: [ACFUG Discuss] css - a little off topic

2006-10-04 Thread Gerrey . Mary-Catherine
Yes, when it comes to CSS, IE stinks.  You can write relatively standard code in Firefox (heck even Safari), and standards are good.  But since the majority of people choose IE, you then have to come up with fixes.  Probably more time consuming, but I start in FF, to get more standard oriented cod