Access > SQL Question

2004-08-18 Thread Donna French
I have a table that I transferred from Access to SQL and had a field setup as auto number. Now I am getting an error message when I try to submit new info to the table in SQL. Here's the error: ODBC Error Code = 23000 (Integrity constraint violation) [Microsoft][ODBC SQL Server Driver][SQL S

Re: BLACKSTONE: Software Development Times Article

2004-08-18 Thread Brian Kotek
Why? They're all fine frameworks. No gasket-blowing in sight (unless one considers your random irrational generalizations as blowing a gasket). - Original Message - From: Alexander Sherwood <[EMAIL PROTECTED]> Date: Wed, 18 Aug 2004 13:53:19 -0400 Subject: RE: BLACKSTONE: Software Developm

CFSELECT selected parameter

2004-08-18 Thread CF Coder2
Sorry if this has been discussed but I'm finding that in the following CFSELECT code, the "selected=8" parameter has no bearing on the default pulldown that's selected when the page is visited.  It appears to basically be broken and a useless parameter.  Have others seen this? Or is this a pilot er

RE: BLACKSTONE: Software Development Times Article

2004-08-18 Thread Matt Liotta
> Didn't realize it was in that context... but okay -- since I read the > other one where you quoted the context you were speaking within > specifically -- the _minor_ revision then is -- "if you don't like the > way the pre-built gateways work, buy or use one someone else has > built", which is st

RE: Event Gateway on BlueDragon, etc. ( was:BLACKSTONE: Software Development Times Article)

2004-08-18 Thread Matt Liotta
That would mean the app server would have to poll the message queue and then invoke a CFC as needed, which could certainly work. However, then you would still need some other application to respond to 3rd party "events" and put them on the queue. At that point, if seems easier just to have a "gatew

RE: BLACKSTONE: Software Development Times Article

2004-08-18 Thread Tangorre, Michael
Nothing wrong with Fusebox. Nothing wrong with any framework or methodology... Whatever works for ya. Michael T. Tangorre   > I'm sorry...I just can't help myself. As I was typing the > above response, I could see a red-faced "FuseBoxer" knee-deep > in a "nested circuit" just blowing a gasket a

Re: SQL date/time issues...

2004-08-18 Thread Greg Morphis
SELECT TO_CHAR(t.startdate,'hh24:mi:ss') AS starttime, TO_CHAR(t.finishdate,'hh24:mi:ss') AS finishtime, LPAD(taskid,5), startdate, finishdate   FROM TASK t WHERE TO_DATE('08/21/2004','mm/dd/') >= TRUNC(t.startdate) AND TO_DATE('08/21/2004','mm/dd/') <= TRUNC(t.finishdate) AND TO_CHAR(TO_D

RE: BLACKSTONE: Software Development Times Article

2004-08-18 Thread Alexander Sherwood
At 01:46 PM 8/18/2004, you wrote: >> It has to do with Mach-II blowing all other frameworks away. That is, >> except Java Server Faces and Struts. >> >Glad you cleared that up. ;) I'm sorry...I just can't help myself. As I was typing the above response, I could see a red-faced "FuseBoxer" knee-de

Re: Event Gateway on BlueDragon, etc. ( was:BLACKSTONE: Software Development Times Article)

2004-08-18 Thread Dick Applebaum
I am new to JMS, so be gentle :) Wouldn't it be practical to use a cfmessage tag to set up a listener... something like:   mode=SetListner   MessageType=queue or topic   MessageName= QueueName or TopicName   Component=path to CFC   Method=Function to invoke /> Couldn't this

RE: BLACKSTONE: Software Development Times Article

2004-08-18 Thread S . Isaac Dealey
>> Excuse me? MM is providing a handful of pre-built >> gateways to begin with, much less having a consistent >> interface provided by MM which allows others who are >> Java knowledgeable to create, package and distribute >> additional gateways. At which point, yes, it is a very >> valid argument.

RE: BLACKSTONE: Software Development Times Article

2004-08-18 Thread Matt Liotta
> It has to do with Mach-II blowing all other frameworks away. That is, > except Java Server Faces and Struts. > Glad you cleared that up. ;) -Matt [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]

Re: Log file reader

2004-08-18 Thread Claude Schneegans
>>Has anyone ever used/seen/have/etc a script that can read and parse IIS log files? Not exactly this, but there is a tag perfect for parsing, see CF_REExtract here: http://www.cftagstore.com/tags/cfreextract.cfm -- ___ REUSE CODE! Use custom tags; See http://w

RE: BLACKSTONE: Software Development Times Article

2004-08-18 Thread Calvin Ward
Hmm, that's an interesting point on flash generation... Did New Atlanta just get left behind big time in the compatability dept? -Original Message- From:  Matt Liotta Date:  8/18/04 8:59 am To:  CF-Talk Subj:  RE: BLACKSTONE: Software Development Times Article I don't know what to do wit

Re: SQL date/time issues...

2004-08-18 Thread Greg Morphis
Anyone have any idea how to go about doing this? >This is irritating me.. it seems like it should work but isnt. > >I have a query.. the base query > >SELECT TO_CHAR(t.startdate,'hh24:mi:ss') AS starttime, >TO_CHAR(t.finishdate,'hh24:mi:ss') AS finishtime, taskid, >startdate, finishdate   >FROM

RE: BLACKSTONE: Software Development Times Article

2004-08-18 Thread Alexander Sherwood
At 01:35 PM 8/18/2004, you wrote: >> Probably. But very few (if any) are using their own application >> schemes instead of . >> >What does that have to do with cflogin or frameworks? > >-Matt It has to do with Mach-II blowing all other frameworks away. That is, except Java Server Faces and Struts

RE: BLACKSTONE: Software Development Times Article

2004-08-18 Thread Matt Liotta
> Excuse me? MM is providing a handful of pre-built gateways to begin > with, much less having a consistent interface provided by MM which > allows others who are Java knowledgeable to create, package and > distribute additional gateways. At which point, yes, it is a very > valid argument. The end

RE: SQL Query problem

2004-08-18 Thread Mark Leder
Still didn't work, returning multiple transactions for any given individual. I clipped this from the results (there should only be one individual and the paid thru should be 7/31/2004, which is the newest (highest) transactionID memberlevelID | email | firstname | lastname | paidthru M | [EMAIL

DSN-less Queries was Re: BLACKSTONE: Software Development Times Article

2004-08-18 Thread S . Isaac Dealey
> On Wednesday 18 Aug 2004 17:28 pm, S. Isaac Dealey wrote: >> And use that for cfquery how? ... I know that I can >> connect to > Well, either write your own cf_query, or a cfquery > object/UDF to behave like > cfquery did back when CF support DSN-less nativly (4.5 > ?)... all you are > doing wit

Re: Event Gateway on BlueDragon, etc. ( was:BLACKSTONE: Software Development Times Article)

2004-08-18 Thread Dick Applebaum
Good answers! Looking forward to the public beta! Dick On Aug 18, 2004, at 9:50 AM, Vince Bonfanti wrote: > Hi Dick, > >  Regarding your first two questions, details of the CFMESSAGE tag will > be >  announced when we release the BD 6.2 public beta (this is a fancy way > of >  saying, "I don'

RE: BLACKSTONE: Software Development Times Article

2004-08-18 Thread S . Isaac Dealey
>> Like all things CF, it's more accessible to people who >> aren't Java experts. >> > Writing an event gateway requires knowledge of Java > therefore yours is not a valid argument. Excuse me? MM is providing a handful of pre-built gateways to begin with, much less having a consistent interface pr

RE: Memory Issues

2004-08-18 Thread Christian Watt
No, right now I have it set at 750mb.  Although I have had it just over a gig, but it does not matter how high I set it, eventually it still surpasses that limit and locks up. Christian -Original Message- From: Peter Farrell [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 18, 2004

RE: Log file reader

2004-08-18 Thread Jim Davis
You'd probably be better off looking for a CF-able Java or COM object. MS has a nice COM-based tool here: http://www.microsoft.com/downloads/details.aspx?displaylang=en e4028-e247-45be-bab9-ac851fc166a4> &familyid=8cde4028-e247-45be-bab9-ac851fc166a4 Jim Davis [Todays Threads] [This Message]

Blackstone summary

2004-08-18 Thread Matt Liotta
The recent Blackstone thread on CF-Talk did what long threads often do on mailing lists; it went off in various tangents making it hard to understand what was being argued and what each person's respective position was. In light of that, I figured I would summarize my position to avoid being misint

Re: Event Gateway on BlueDragon, etc.

2004-08-18 Thread Daniel Ganter
We've customers running Fusebox3, Fusebox4 and Mach-ii applications on BlueDragon (including the technology preview .NET version of BlueDragon). This area will highlight the benefits of using BlueDragon with the various Fusebox versions. Apologies for the confusion. Regards, Dan Daniel Ganter N

RE: Event Gateway on BlueDragon, etc. ( was:BLACKSTONE: Software Development Times Article)

2004-08-18 Thread Matt Liotta
> 3) your thoughts on the tradeoffs of a cfmessage tag vs an event gateway > One major tradeoff is the ability for CFML to be invoked based on a message. With a cfmessage tag you still need the CFM or CFC making use of it to execute. An event gateway or something of similar design would invoke CFM

RE: SQL Query problem

2004-08-18 Thread Mark Leder
I'll give this a try and let you know.  Thanks for your response.   _   From: Marc Lowe [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 18, 2004 12:54 PM To: CF-Talk Subject: Re: SQL Query problem I left a lot of your query out but you should be able to look at this and see the biggest di

RE: SQL Query problem

2004-08-18 Thread Mark Leder
???   _   From: Tangorre, Michael [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 18, 2004 12:58 PM To: CF-Talk Subject: RE: SQL Query problem All the time you spent searching different solutions you could have fixed the table strcuture and rewrote the code 5x over. Suck it up Gel :-) Ta

RE: SUSPECT: RE: slow Java call - Determining physical length of string - Pt 2

2004-08-18 Thread Dirk Sieber
We're starting to run into that as well...some of the numbers seem to be quite off - just when we thought we had a solution.  Anyone have any other ideas on how we can accomplish this?  This doesn't have to be cross-platform - any way to call a native Windows function to get the correct size? Th

RE: SQL Query problem

2004-08-18 Thread Tangorre, Michael
Sorry about that. Wrong list!!! That was suppose to go to cf-community. :-) Michael T. Tangorre   > All the time you spent searching different solutions you > could have fixed the table strcuture and rewrote the code 5x > over. Suck it up Gel > :-) Take the high road. [Todays Threads] [This

RE: SQL Query problem

2004-08-18 Thread Tangorre, Michael
All the time you spent searching different solutions you could have fixed the table strcuture and rewrote the code 5x over. Suck it up Gel :-) Take the high road. Michael T. Tangorre [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]

SQL date/time issues...

2004-08-18 Thread Greg Morphis
This is irritating me.. it seems like it should work but isnt. I have a query.. the base query SELECT TO_CHAR(t.startdate,'hh24:mi:ss') AS starttime, TO_CHAR(t.finishdate,'hh24:mi:ss') AS finishtime, taskid, startdate, finishdate   FROM TASK t returns STARTTIME FINISHTIME LPAD(TASKID,5) STAR

Re: BLACKSTONE: Software Development Times Article

2004-08-18 Thread Thomas Chiverton
On Wednesday 18 Aug 2004 17:28 pm, S. Isaac Dealey wrote: > And use that for cfquery how? ... I know that I can connect to Well, either write your own cf_query, or a cfquery object/UDF to behave like cfquery did back when CF support DSN-less nativly (4.5 ?)... all you are doing with hacking the

Re: SQL Query problem

2004-08-18 Thread Marc Lowe
I left a lot of your query out but you should be able to look at this and see the biggest differences. SELECT m.memberID, m.firstname, m.lastname,    MAX(t.transactionID) as maxID FROM members m INNER JOIN trans t ON t.memberID = m.memberID GROUP BY m.memberID, m.firstname, m.lastname Hope t

RE: Event Gateway on BlueDragon, etc. ( was:BLACKSTONE: Software Development Times Article)

2004-08-18 Thread Vince Bonfanti
Hi Dick, Regarding your first two questions, details of the CFMESSAGE tag will be announced when we release the BD 6.2 public beta (this is a fancy way of saying, "I don't know yet"). Regarding "...tradeoffs of a cfmessage tag vs an event gateway...", three answers:   1. We started work on the C

Re: Event Gateway on BlueDragon, etc. ( was:BLACKSTONE: Software Development Times Article)

2004-08-18 Thread Damien McKenna
On Aug 18, 2004, at 11:05 AM, Vince Bonfanti wrote: > Now that we also have the BlueDragon "infrastructure" in place (on > both Java > and .NET), adding new features can be done fairly rapidly. Let the good times roll! -- Damien McKenna - Web Developer - [EMAIL PROTECTED] The Limu Company - http

Re: Consuming CFC web methods in VB.NET

2004-08-18 Thread Dick Applebaum
It's Rob's creation -- so it prolly is. When I first encountered it. i saw it as necromancer --a whole 'nother game :) Dick On Aug 18, 2004, at 9:00 AM, Alexander Sherwood wrote: > At 11:57 AM 8/18/2004, you wrote: > >  >http://www.rohanclan.com/products/neuromancer/ > >  Dick - I gotta ask: i

RE: SQL Query problem

2004-08-18 Thread Mark Leder
Will this work ? Error Executing Database Query.   [Macromedia][SQLServer JDBC Driver][SQLServer]Incorrect syntax near the keyword 'WHERE'.      The error occurred in C:\Inetpub\REIAColumbus\admin\members\searchFunction\searchOneOfTwo.cfm: line 198 Called from C:\Inetpub\REIAColumbus\admin\membe

Re: Event Gateway on BlueDragon, etc. ( was:BLACKSTONE: Software Development Times Article)

2004-08-18 Thread Dick Applebaum
On Aug 18, 2004, at 8:05 AM, Vince Bonfanti wrote: >  Second, based on the information that's available publicly so far, > there's >  nothing to technically prevent us from implementing an event gateway > in >  BlueDragon, if we choose to do so. Indeed, we've already got a working >  prototype o

Re: BLACKSTONE: Software Development Times Article

2004-08-18 Thread S . Isaac Dealey
> On Wednesday 18 Aug 2004 14:34 pm, S. Isaac Dealey wrote: >> CF-Admin... If I could get DSN-less connections with >> CFMX, I'd be all >> over it. > Umm, you can, with the service factory java objects... And use that for cfquery how? ... I know that I can connect to datasources without using a D

Re: keeping form data during server-side validation

2004-08-18 Thread Barney Boisvert
If you're CFLOCATIONing back to the form page, then you'll lose the submitted values.  To repopulate the form, you'll either have to submit the form to itself, include the form in the action page (with CFINCLUDE), or set the form data to some persistant scope (session or client), and then read it o

RE: SQL Query problem

2004-08-18 Thread Alexander Sherwood
At 12:05 PM 8/18/2004, you wrote: >OK, a couple of things: >1) Below is the complete code for the query page. SorryI meant the actual SQL code that gets passed to the DB. CF will display the actual, parsed SQL code in the debugging output. Could you post this? Thanks! -- Alex [Todays Threa

RE: BLACKSTONE: Software Development Times Article

2004-08-18 Thread Matt Liotta
> Declaring that it's not a valid argument does not make it so. As many > people > have already stated, there will be several built in gateways. ColdFusion > developers will be able to start using these from day one with no > knowledge > of Java. > You are missing the context of the thread though.

Re: keeping form data during server-side validation

2004-08-18 Thread Patricia Lee
I see a cflocation in your code for the action page. When you cflocate back to the form page you lose your form variables. This is why they don't display for you.  The cfparam, in this case, will stop any errors, but it won't magically keep your values. The easiest (but not only) way to do what

RE: SQL Query problem

2004-08-18 Thread Mark Leder
OK, a couple of things: 1) Below is the complete code for the query page. 2) Go to www.markleder.com/query.cfm There are two results screenshots: Shot 1 = the results from this query Shot 2 = a detail zoom for one of the members (this is included for clarification), in this case, I'm getting dup

Re: Consuming CFC web methods in VB.NET

2004-08-18 Thread Alexander Sherwood
At 11:57 AM 8/18/2004, you wrote: >http://www.rohanclan.com/products/neuromancer/ Dick - I gotta ask: is Nueromancer a D&D name? -- Alex [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]

Re: Consuming CFC web methods in VB.NET

2004-08-18 Thread Dick Applebaum
I have open-sourced a CFC that includes  functions that convert a cf   query or cf array to/from a thinArray ( a special-format, delimited   list ).  The thinArray can then be transmitted to/from a web service as   a single string within an XML (WDDX) packet.  It has the additional   advantage of r

RE: Event Gateway on BlueDragon, etc.

2004-08-18 Thread Alexander Sherwood
At 11:44 AM 8/18/2004, you wrote:\ Quick question, Vince. On the BD product page, a graphic neare the bottom asks "How can I leverage Fusebox with BlueDragon?" Is this a teaser for some FB-specific tags in BD, or more geared towards showing how FB works within the standard CFML tag/function set?

Log file reader

2004-08-18 Thread Ray Champagne
Has anyone ever used/seen/have/etc a script that can read and parse IIS log files?  I want to write a custom stats package for my company, but figured why reinvent the wheel - this script would be out there somewhere.  I am pretty flexible, I just am lazy and don't want to write the code to par

RE: Event Gateway on BlueDragon, etc. ( was:BLACKSTONE: Software Development Times Article)

2004-08-18 Thread Vince Bonfanti
Hi Adrian, Glad you asked! Here's a list of BlueDragon-certified hosting providers:   http://www.newatlanta.com/products/bluedragon/partners/hosting.cfm Vince Bonfanti New Atlanta Communications, LLC http://www.newatlanta.com From: Adrian Lynch [mailto:[EMAIL

Re: Memory Issues

2004-08-18 Thread Peter Farrell
Check this out: http://www-106.ibm.com/developerworks/java/library/j-garbage-collection.html Are you running JRUN with Updater 3? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]

RE: Event Gateway on BlueDragon, etc. ( was:BLACKSTONE: Software Development Times Article)

2004-08-18 Thread Adrian Lynch
Hey Vince, I don't suppose you have a list or a link to a bunch of BD hosting companies? I would have emailed you personally but I figured it would be cool for everyone else to see your answer! :OD Ade "never spoken to Vince before in my life" Lynch -Original Message- From: Alexander She

RE: BLACKSTONE: Software Development Times Article

2004-08-18 Thread Benjamin S. Rogers
> > Like all things CF, it's more accessible to people who aren't Java > > experts. > > > Writing an event gateway requires knowledge of Java therefore yours is not > a valid argument. Declaring that it's not a valid argument does not make it so. As many people have already stated, there will be

RE: SQL Query problem

2004-08-18 Thread Alexander Sherwood
At 11:08 AM 8/18/2004, you wrote: >OK, you asked for it :o)  -- the select statement was my latest try at >retrieving just the highest numbered transaction ID and corresponding data >for each member.  FYI - the filtering statements are only invoked after >someone does a new search from a form.  The

Re: Memory Issues

2004-08-18 Thread Peter Farrell
Christian, What's your max memory heap size?  Is it over 1.8 GB? .pjf maepub [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]

Re: BLACKSTONE: Software Development Times Article

2004-08-18 Thread Alexander Sherwood
At 10:36 AM 8/18/2004, you wrote: >What are you talking about? If you're being serious, this doesn't make >any sense at all. If you're joking, it's not funny. I'm serious. I just ported the Mach-II framework to a nice, compact 12K executable for my Commodore-64. Now I can connect my 64 (and my old

RE: Event Gateway on BlueDragon, etc. ( was:BLACKSTONE: Software Development Times Article)

2004-08-18 Thread Alexander Sherwood
At 11:05 AM 8/18/2004, you wrote: This is good news, Vince. Thank's for the update and keeping the greater CF community in mind. Keep up the good work. -- Alex Sherwood >Now that we also have the BlueDragon "infrastructure" in place (on both Java >and .NET), adding new features can be done fai

RE: SQL Query problem

2004-08-18 Thread Mark Leder
OK, you asked for it :o)  -- the select statement was my latest try at retrieving just the highest numbered transaction ID and corresponding data for each member.  FYI - the filtering statements are only invoked after someone does a new search from a form.  The inital results, which is what I am af

RE: Event Gateway on BlueDragon, etc. ( was:BLACKSTONE: Software Development Times Article)

2004-08-18 Thread Vince Bonfanti
Hi Tony, First, Matt Liotta does not represent nor speak for New Atlanta. If you have a problem with New Atlanta or BlueDragon, you should contact me; if you have a problem with Matt you should take it up with him and leave New Atlanta and BlueDragon out of it. Second, based on the information th

RE: BLACKSTONE: Software Development Times Article

2004-08-18 Thread Gavin Brook
I've been following this thread and I wanted to share my thoughts... I've been developing for many years now and I'm a firm believer in using the right technology for the right job. Arguing about whether to use a Macromedia supplied tag or to write something in Java is a personal choice. If the

Re: Query from within a cfscript

2004-08-18 Thread Howie Hamlin
Well, paint me stupid. Thanks, Howie   - Original Message -   From: Greg Stewart   To: CF-Talk   Sent: Wednesday, August 18, 2004 10:53 AM   Subject: Re: Query from within a cfscript   True but you still need to cerate a function called cfquery, here is   the code from the article:  

Re: Query from within a cfscript

2004-08-18 Thread Howie Hamlin
I'm getting: Variable CFQUERY is undefined. Thanks, Howie   - Original Message -   From: Adrian Lynch   To: CF-Talk   Sent: Wednesday, August 18, 2004 10:54 AM   Subject: RE: Query from within a cfscript   I didn't read the article, but it seems the dude has a cfquery function.   So

Re: Query from within a cfscript

2004-08-18 Thread Greg Stewart
True but you still need to cerate a function called cfquery, here is the code from the article:                 dbtype="#arguments.dbType#"> #preserveSingleQuotes(arguments.SQLString)# You'll need to have that somewhere in your template or application.cfm Cheers G On Wed, 18 Aug 2004 1

RE: SQL Query problem

2004-08-18 Thread Alexander Sherwood
At 10:14 AM 8/18/2004, you wrote: >MemberID from the members table corresponds to the memberID in the >transaction table.  So I must be writing the join wrong? Seems that way. Post the whole query, just as you have it the code. -- Alex [Todays Threads] [This Message] [Subscription] [Fast U

Re: BLACKSTONE: Software Development Times Article

2004-08-18 Thread Doug White
I particularly like the feature in Blackstone of being able to incorporate PGP encryption for better security of personal information collected on e-commerce applications, but the document and reporting functionality is awesome as well. Event management is probably a feature set that I would rarely

RE: Query from within a cfscript

2004-08-18 Thread Adrian Lynch
I didn't read the article, but it seems the dude has a cfquery function. Sorry I deleted your original email but what error are you getting? Ade -Original Message- From: Howie Hamlin [mailto:[EMAIL PROTECTED] Sent: 18 August 2004 15:43 To: CF-Talk Subject: Re: Query from within a cfscript

CF DB connections are timing out

2004-08-18 Thread Phill B
Some thing is causing CF to redline on DB connections. What would be the best way to track the problem down? -- Phillip B. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]

Re: Query from within a cfscript

2004-08-18 Thread Howie Hamlin
No, I'm basing my code from this article: http://www.macromedia.com/devnet/mx/coldfusion/extreme/cftags_cfscript.html The sample code in the article seems to call a CFQuery from within a CFSCRIPT block:   SQLString = "Select * From LoginInfo where   UserID='BobZ' and Password = 'Ads10'";   DAT

RE: BLACKSTONE: Software Development Times Article

2004-08-18 Thread Matt Liotta
> Like all things CF, it's more accessible to people who aren't Java > experts. > Writing an event gateway requires knowledge of Java therefore yours is not a valid argument. > After all, a structure is just a Java object. So what makes CF > structures any better than using the underlying Java ob

RE: Query from within a cfscript

2004-08-18 Thread Adrian Lynch
Have you got a function of your own called CFQuery()? Ade -Original Message- From: Howie Hamlin [mailto:[EMAIL PROTECTED] Sent: 18 August 2004 15:31 To: CF-Talk Subject: Re: Query from within a cfscript Here is the code (it's supposed to log to a table): function CSLog(CustomerID,Cate

Re: BLACKSTONE: Software Development Times Article

2004-08-18 Thread Brian Kotek
What are you talking about? If you're being serious, this doesn't make any sense at all. If you're joking, it's not funny. - Original Message - From: Alexander Sherwood <[EMAIL PROTECTED]> Date: Wed, 18 Aug 2004 10:00:05 -0400 Subject: RE: BLACKSTONE: Software Development Times Article To:

Re: BLACKSTONE: Software Development Times Article

2004-08-18 Thread Thomas Chiverton
On Wednesday 18 Aug 2004 14:34 pm, S. Isaac Dealey wrote: > CF-Admin... If I could get DSN-less connections with CFMX, I'd be all > over it. Umm, you can, with the service factory java objects... -- Tom Chiverton Advanced ColdFusion Programmer Tel: +44(0)1749 834997 email: [EMAIL PROTECTED] Bl

Re: Query from within a cfscript

2004-08-18 Thread Howie Hamlin
Yes, this helps somewhat but I'd really like to get the whole thing wrapped up in one function call.  All the code is supposed to do is write information to a logging table so it should really be simple.   Thanks, Howie   - Original Message -   From: Greg Stewart   To: CF-Talk   Sent:

RE: Count Online Users Conundrum

2004-08-18 Thread Tim Blair
One thing: > What you'll need to do is add *two* timestamps to each user -- one for > when they first accessed the system, and one when they last requested a > page.  Your "15 minute check" should then use the difference between > these values to determine whether the user has been inactive for 15

Re: Query from within a cfscript

2004-08-18 Thread Howie Hamlin
Here is the code (it's supposed to log to a table): function CSLog(CustomerID,Category,SubCategory,I0,I1,I2,I3,I4,Description){ try{   SQLString = "Insert into Log (Category,SubCategory,I0,I1,I2,I3,I4,Description,When) Values    (#Arguments.Category#,#Arguments.SubCategory#,'#Argume

Re: Query from within a cfscript

2004-08-18 Thread Greg Stewart
Hi, Could you post your code? In the meantime, here is how I went about it: http://gregs.tcias.co.uk/cold_fusion/outputting_queries_with_cfscript.php I based it on the same example but opted for placing the query in a CFC and invoking it using CreateObject(); Hope this helps a little G On Wed,

RE: BLACKSTONE: Software Development Times Article

2004-08-18 Thread S . Isaac Dealey
> If the gateway doesn't support FuseBox 4.5 circuits and > the FLiP process (not to mention .qry and .dsp files), > then MACR should go with Mach-II listeners. > Mach-II is really the best choice to build the forthcoming > remote Java --> CFC invocation event-based gateway, by > far. Ummm... no.

RE: Query from within a cfscript

2004-08-18 Thread Tangorre, Michael
Post the code. > Any ideas? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]

Query from within a cfscript

2004-08-18 Thread Howie Hamlin
I'm trying to do a CFQuery from within a cfscript and it's not working.  I'm using the latest CFMX 6.1 and I'm basing my code off of this article: http://www.macromedia.com/devnet/mx/coldfusion/extreme/cftags_cfscript.html However, when I call my function I the following error: Variable CFQUERY

Re: Count Online Users Conundrum

2004-08-18 Thread Sung Woo
Hi Tim, Thanks so much for the breakdown.  I got the code from easycfm.com and didn't think to really analyze it.  I'll make the changes you suggested and let you know if I run into anything.  Thanks again! - Sung >Sung, > >> What happens is that at the end of the day (I run an intranet where >t

Re: One More Stupid Query Question

2004-08-18 Thread Jochem van Dieten
Les Mizzell wrote: > > SELECT * FROM news_pr > Where Headline like '%#var1#%' > or BodyText like '%#var2#%' > or tagline like '%#var3#%' > and pr_status='Active' > and Year(pr_date) = #FORM.pubDATE# > order by pr_date desc > > > However, if I enter "1998" in the form, it's still returning result

RE: SQL Query problem

2004-08-18 Thread Mark Leder
MemberID from the members table corresponds to the memberID in the transaction table.  So I must be writing the join wrong?   _   From: Alexander Sherwood [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 18, 2004 10:02 AM To: CF-Talk Subject: Re: SQL Query problem At 10:00 AM 8/18/2004, yo

Re: wwokey hole was Re: cf tree menu

2004-08-18 Thread S . Isaac Dealey
> On Monday 16 Aug 2004 16:38 pm, S. Isaac Dealey wrote: >> > Wookey Hole Road, WELLS. BA5 1AF >> I love that your office is in a place called "Wookey >> Hole". :) > I've still not managed to come up with some sort of of > Star Wars joke about > it... :-) Oh come on, they had a Wookey (it's not s

Re: One More Stupid Query Question

2004-08-18 Thread Damien McKenna
On Aug 17, 2004, at 11:42 PM, Les Mizzell wrote: > SELECT * FROM news_pr > Where Headline like '%#var1#%' > or BodyText like '%#var2#%' > or tagline like '%#var3#%' > and pr_status='Active' > and Year(pr_date) = #FORM.pubDATE# > order by pr_date desc Make sure you are cleaning those variables befo

Re: BLACKSTONE: Software Development Times Article

2004-08-18 Thread Charlie Griefer
I'm more silenced at the notion of Tony representing the "soft spoken"  :) (but while there is a short silence, I'm going to throw in a soft spoken request that this thread move to community?) Alexander Sherwood wrote: >At 09:56 AM 8/18/2004, you wrote: >   > >>>matt, i respect your intelligenc

Re: SQL Query problem

2004-08-18 Thread Alexander Sherwood
At 10:00 AM 8/18/2004, you wrote: >This is giving me fits.  In a membership listing, each member could have >many transactions (one to many relationship). I want to retrieve each member >ID, and their corresponding most recent (MAX) transactionID.  The memberID >joins the two tables. > >I've tried

RE: BLACKSTONE: Software Development Times Article

2004-08-18 Thread Alexander Sherwood
At 09:56 AM 8/18/2004, you wrote: >> matt, i respect your intelligence, i respect your message, >> you are way off the scales on the iq chart im sure, >> butyour delivery sucks. >> if your personality was half of what your intelligence was, >> man, im sure you could be president.  i hope th

Datasource info from CF5

2004-08-18 Thread Hays, Duncan
Still using CF5 here and in the CF admin page that lists our native datasources I would also like to see the host string or server variable so that we can know at a glance what db the DSN is connecting to. Does anyone know the name of the query that is generating this list? Or some other way to get

SQL Query problem

2004-08-18 Thread Mark Leder
This is giving me fits.  In a membership listing, each member could have many transactions (one to many relationship). I want to retrieve each member ID, and their corresponding most recent (MAX) transactionID.  The memberID joins the two tables. I've tried several ways without success. The statem

RE: Count Online Users Conundrum

2004-08-18 Thread Tim Blair
Sung, > What happens is that at the end of the day (I run an intranet where there > are about 200 peak users), around midnight, it still shows 80 or so users > online!  What do you think could be causing this? Does the code you run to "report" on the user sessions run the code you posted first?  

RE: Consuming CFC web methods in VB.NET

2004-08-18 Thread Dave Watts
> This is my last stab at this problem. No other message boards have > been able to help me. > > ... > > > returntype="query"> ... You won't be able to consume CF query objects from .NET, I don't think. There's no SOAP-specific or XML Schema-specific definition of a query object. You can use so

RE: BLACKSTONE: Software Development Times Article

2004-08-18 Thread Tangorre, Michael
> matt, i respect your intelligence, i respect your message, > you are way off the scales on the iq chart im sure, > butyour delivery sucks. > if your personality was half of what your intelligence was, > man, im sure you could be president.  i hope this doesnt > offend you, its not intend

Re: BLACKSTONE: Software Development Times Article

2004-08-18 Thread Tony Weeg
you know what man, i dont want, wait a minute, YOU CANT DO ANYTHING WITH ME, you dont have that option, friend, sorry. now, mike d, he could throw him off the list, sure... im not here to get into a pissing match with you matt, i just tend to be the voice of the soft spoken crowd. the crowd that

Re: blackstone, what would be sweet

2004-08-18 Thread S . Isaac Dealey
> Hrm...for some reason I just connected "scripts" to SQL > injection and > HTML to insertion of, well, tags (including

RE: BLACKSTONE: Software Development Times Article

2004-08-18 Thread S . Isaac Dealey
>> Think about this... don't like the way CFMX handles >> webservices? >> Thinks its buggy and a pain to use?  Just don't want to >> use Axis >> because you have a better idea? Write your own event >> gateway for >> webservices and that utilizes some other SOAP engine. >> Want to >> implement SOAP

RE: BLACKSTONE: Software Development Times Article

2004-08-18 Thread Micha Schopman
Personally, the moment BlueDragon came out I thought.. "those guys actually give us what the community always wanted". BlueDragon just filled up that spot which has always been on the request list of many developers. And also personally, I don't think I will ever use Flash forms, or auto-generated

Re: Consuming CFC web methods in VB.NET

2004-08-18 Thread Adam Haskell
I've always contended that sending anything over a webservice other than simple values is going to get you in trouble. Even in CF - CF communications I think sending anything other than text is asking for trouble. I recomend using one of the many functions on cflib.org to convert the complex object

Re: Count Online Users Conundrum

2004-08-18 Thread Sung Woo
Ray, is there any way I could streamline the locks?  This is in the application.cfm page, so it's being hit quite often, and I'd like it to be as efficient as possible.  Thanks! - Sung >Not that it helps much, but that is some pretty awful code. The locks >are too much and the code generating cfi

Re: Count Online Users Conundrum

2004-08-18 Thread Sung Woo
Hi Ryan, Here are my results: 4 12 14 10 11 15 8 5 3 8 10 12 10 7 4 13 14 14 14 13 15 7 6 3 12 0 6 11 5 6 11 4 4 12 6 11 4 4 11 6 14 13 15 10 9 9 3 15 9 6 2 12 9 10 13 8 11 5 3 13 3 3 3 2 2 4 2 2 5 2 2 12 3 2 4 9 2 15 4 7 2 9 6 10 1 5 14 1 1 13 8 11 14 14 1 1 15 6 9 4 8 5 7 1 1 1 1 6 1 12 0 0 0 0

Re: wwokey hole was Re: cf tree menu

2004-08-18 Thread Thomas Chiverton
On Monday 16 Aug 2004 16:38 pm, S. Isaac Dealey wrote: > > Wookey Hole Road, WELLS. BA5 1AF > I love that your office is in a place called "Wookey Hole". :) I've still not managed to come up with some sort of of Star Wars joke about it... :-) -- Tom Chiverton Advanced ColdFusion Programmer Te

RE: BLACKSTONE: Software Development Times Article

2004-08-18 Thread Matt Liotta
I don't know what to do with you Tony. You keep posting comments with no basis in facts that don't make much sense anyway. I'd really like to avoid addressing them or falling prey to my desire to respond negatively. Is that what you want? Is there some point to your comments? For the rest of you r

<    1   2   3   >