Making a rapid search I found this link, it could help you
http://blogs.msdn.com/sqltips/archive/2005/09/16/469136.aspx
Greetings
-Original Message-
From: John Stottlemire [mailto:[EMAIL PROTECTED]
Sent: Wednesday, April 04, 2007 11:56 PM
To: CF-Talk
Subject: Re: MS Access Primary Key
2 second search in Google revealed:
http://msdn2.microsoft.com/en-us/library/bb208516.aspx
"This e-mail is from Reed Exhibitions (Gateway House, 28 The Quadrant,
Richmond, Surrey, TW9 1DN, United Kingdom), a division of Reed Business,
Registered in England, Number 678540. It contains informat
Come on, someone has to know how to do this
> Anyone know of a way to find the Primary Key in a table using CFMX and
> SQL?
>
> I know that queryname.columnlist returns the field names, but I'm
> trying to determine the primary key of the database table as well.
>
> Thanks in advance.
~~~
> -Original Message-
> From: Dan Vega [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, April 04, 2007 9:08 PM
> To: CF-Talk
> Subject: Quick Books Import
>
> I am looking for someone who is familiar with quick books. I have a
> customer
> who has about 30 online orders per day. The orders are
> I am looking for someone who is familiar with quick books. I have a customer
> who has about 30 online orders per day. The orders are not tied into quick
> books in any way so at the end of each day the customer has to go back and
> manually insert each order. I have never used Quick Books and I
Isn't that what all these boxes are? Just some of them are not standard
PC's are using customized versions of Linux...
It looks like it's really easy to set things up with Apache 2.2... From
docs: http://httpd.apache.org/docs/2.2/mod/mod_proxy.html
ProxyPass /special-area http://special.examp
I can't really answer your question, but I do know that Quicken can import a
correctly formatted file. I used to use a tool on my Palm that would dump
out a plain text file, and then Quicken could import it. Do some googling,
I'll bet there's a way to do it.
On 4/4/07, Dan Vega <[EMAIL PROTECTED
I am looking for someone who is familiar with quick books. I have a customer
who has about 30 online orders per day. The orders are not tied into quick
books in any way so at the end of each day the customer has to go back and
manually insert each order. I have never used Quick Books and I am not s
> On 4/4/07, Peter Boughton <[EMAIL PROTECTED]> wrote:
> >
> > I need to get a list of all the TODOs in a list of (primarily .cfm)
> files.
> >
> > In the unlikely event of people not being familiar with TODOs,
> they're
> > just
> > CFML comments like this:
> >
> > The presence of the TODO: then
Radware!!! :) but $$$
Russ is onto something there with LVS. All a radware is, is a PC running
their version of linux
Eric
On 4/4/07, Jacob <[EMAIL PROTECTED]> wrote:
>
> I have used both Radware WSD and Cisco Content Services Switch.
>
> Both worked fine for me. Not *cheap* though.
>
>
XML/XSLT does not query databases or produce structures that can be forwarded
to web services and other applications. CF is a good framework/backend tool
that can serve raw data to be altered by XSL.
- Original Message
From: Larry Lyons <[EMAIL PROTECTED]>
To: CF-Talk
Sent: Wednesday,
Thanks Dave and Kevin, this is indeed very helpful.
The plan is at business plan stage now. I was asked "does this WSE
Security thing mean it's going to be doable if we go ahead or not?"
The management people are discussing all the business and legal
aspects of the two sites working together, an
I have used both Radware WSD and Cisco Content Services Switch.
Both worked fine for me. Not *cheap* though.
-Original Message-
From: John Paul Ashenfelter [mailto:[EMAIL PROTECTED]
Sent: Wednesday, April 04, 2007 6:58 AM
To: CF-Talk
Subject: Hardware load balancers (lower-end)
Folks,
Another option at CFLIB - http://www.cflib.org/udf.cfm/reget
On 4/4/07, Ben Nadel <[EMAIL PROTECTED]> wrote:
> Pete,
>
> I don't know what the REExtract thing does exactly, but it might be
> something like this:
>
> http://www.bennadel.com/index.cfm?dax=snippets:11.view
>
> This users Java regular
Pete,
I don't know what the REExtract thing does exactly, but it might be
something like this:
http://www.bennadel.com/index.cfm?dax=snippets:11.view
This users Java regular expressions to grab all matching content and
return it in a ColdFusion array.
..
Ben Nadel
Certifie
> I don't pay for code though - let me know when it's open-source. ;)
Out of curiosity, do you get paid for writing code yourself? I'm genuinely
curious.
Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
Fig Leaf Software provides the highest caliber vendor-authorized
instruction at our
Thanks Claude, that looks impressive.
I don't pay for code though - let me know when it's open-source. ;)
>>>I'm sure there has to be a better way of doing it than that,
>
>You're quite right:
>Have a look at CF_REextract:
>http://www.contentbox.com/claude/customtags/REextract/testREextract.cfm
> Have a general question about XML/XSLT and CF. One of the
> powers that be is making noises about limiting the use of CF
> etc., etc., etc. One of the arguments he's using is that
> XML/XSLT can handle most data display. Unfortunately I know
> know enough about XML/XSLT to discuss the issue i
> I'd prefer a packaged hardware solution that supports sticky sessions
> -- the app was not really designed for clustering. Something
> like an old Cisco LocalDirector off ebay is probably about
> the right speed!
eBay and uBid are your friends here. I've had better success with uBid for
comput
D'oh, I knew I should have put a "please don't refer me to the Eclipse Task
view" in my post. :P
The Task list isn't flexible enough for what I'm doing.
(Which is building an interface for managing a project with, which will be
scanning all the files and doing other stuff as well as listing TODO
The answer: A circle is equal to a square and a piece of pie.
just in case someone was looking for something psuedo-meaningful in this
thread :).
~|
ColdFusion MX7 and Flex 2
Build sales & marketing dashboard RIAâs fo
I know you said hardware, but if you're not going to implement redundancy
anyway, you might just want to use a software solution like Apache's
mod_proxy_balancer or LVS. Can install it on top of Free VMWare Server, using
CentOS and have a total cost of $0 (plus time required to implement.
Wi
Here is the ColdFusion and Fusebox news:
* 10 reasons to attend CFUNITED
* Topic survey - win a ticket to CFUNITED http://cfunited.com/go/survey
* New CFUNITED podcasts released http://cfunited.com/blog/index.cfm/podcast
- Kelly Tetterton - Managing a Project: From the Developer's Point of View
>>I'm sure there has to be a better way of doing it than that,
You're quite right:
Have a look at CF_REextract:
http://www.contentbox.com/claude/customtags/REextract/testREextract.cfm
--
___
REUSE CODE! Use custom tags;
See http://www.contentbox.com/claude/cu
> >Not seeing any list traffic..so I thought I'd make my own ;-)
>
> You guys start goin into convultions when there's no list traffic dont'cha!
> :)
>
> Will
Yep...as soon as I see no traffic I start thinking there is a US holiday I
don't
know about ;-)
Bryan Stevenson B.Comm.
VP & Directo
Peter,
Open your site as a project in CFEclipse, then find the Tasks view (where
view=panel). Alter the filter on the tasks view to show only tasks from the
currently open project, then open one of the .cfm files from your project.
Instantly you should see a list of all the tasks in your project.
Looking for programmer who can show me how to capture basic test data from
Captivate2 project for import into Db using CF. I can provide sample test.
$50 hr. - up to 2 hours to develop sample code for capturing test score, users
answers.
Hope this is acceptable post. I'm under time constraints
Check out the javascript on
https://wmg.tmomail.net/customer_site/jsp/messaging_lo.jsp It will not let you
past 140 characters.
>Does anybody have a really good way to create the equal of "maxlength"
>on a text area? The server running site in question is only running CF 6
>something, not 7, s
>Not seeing any list traffic..so I thought I'd make my own ;-)
You guys start goin into convultions when there's no list traffic dont'cha!
:)
Will
~|
Upgrade to Adobe ColdFusion MX7
The most significant release in over 10 y
Well, it's not a brain fart. That query is kinda kinky.
Use this as an example, replacing your tables and fields, it should work
BASED ON DATE!
SELECT DISTINCT T.CustomerID, T.TransactionDate, T.ID AS InvoiceID
FROM dbo.Transactions T INNER JOIN
(SELECT MAX(T
There is way it would be a SESSION with a super long timeout - that
would eventually kill the server I think (as the session information
would be stored in the server's RAM). It must be a cookie is my guess.
..
Ben Nadel
Certified Advanced ColdFusion MX7 Developer
www.bennade
Steve LaBadie, Web Manager
East Stroudsburg University
200 Prospect St.
East Stroudsburg, Pa 18301
570-422-3999
[EMAIL PROTECTED]
http://www.esu.edu
-Original Message-
From: Charlie Griefer [mailto:[EMAIL PROTECTED]
Sent: Wednesday, April 04, 2007 3:55 PM
To: CF-Talk
Subject: Re: CFIF -
1) just curious... why not use and omit the
rather than have an empty condition?
2) is URL.showAll a numeric value or a boolean? at one point you set
it as "YES"... but in your conditional you're evaluating whether or
not it's less than 25?
On 4/4/07, Steve LaBadie <[EMAIL PROTECTED]> wrote:
>
Seems like you answered your own post :-)
"This e-mail is from Reed Exhibitions (Gateway House, 28 The Quadrant,
Richmond, Surrey, TW9 1DN, United Kingdom), a division of Reed Business,
Registered in England, Number 678540. It contains information which is
confidential and may also be privil
Likewise - until just now when it's kicked in.
>Not seeing any list traffic..so I thought I'd make my own ;-)
>
>Bryan Stevenson B.Comm.
>VP & Director of E-Commerce Development
>Electric Edge Systems Group Inc.
>phone: 250.480.0642
>fax: 250.480.1264
>cell: 250.920.8830
>e-mail: [EMAIL PROTE
Good morning,
I have a checkbox in a Flash Form and I am trying to get the value of it
when I submit it. All that is getting sent to the server is true and false.
The code looks like this:
This is inside of a cfoutput query. What I want is to get the group ID and
use that as the input value inst
Need more info: What would the query be to return the last invoice for a
single customer?
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]
Sent: Wednesday, April 04, 2007 8:58 AM
To: CF-Talk
Subject: SQL Query Help
having brain fart here ... ughh
scenario: customer
> When I return to the Adobe Forums on the same
> computer, I am still logged in.
Not having used the Adobe Forums myself, I can't say how they do it
specifically, but it could be that they are setting a cookie with a
session ID of some kind outside the usual ColdFusion session cookies
that has a
This is probably a stupid question, but I have no pride.
Consider the Adobe Forums. Let's say I login to the forums on my computer at
work. Now, let's say I close my browser, go home, call in sick the next day,
and return to the office a day later. When I return to the Adobe Forums on the
sa
Assuming the invoice numbers increase each time, you can use MAX() and
GROUP BY to get what you need.
SELECT customer, MAX(invoiceNum) AS lastNum
FROM table
GROUP BY customer
If invoices are not numbered sequentially, hopefully you have a date
field that you can add to the grouping.
M!ke
-
I need to get a list of all the TODOs in a list of (primarily .cfm) files.
In the unlikely event of people not being familiar with TODOs, they're just
CFML comments like this:
The presence of the TODO: then flags up that something needs to be
addressed. Very useful when you want to shove in some
Not seeing any list traffic..so I thought I'd make my own ;-)
Bryan Stevenson B.Comm.
VP & Director of E-Commerce Development
Electric Edge Systems Group Inc.
phone: 250.480.0642
fax: 250.480.1264
cell: 250.920.8830
e-mail: [EMAIL PROTECTED]
web: www.electricedgesystems.com
Notice:
This messa
I have a frame in coldfusion that only displays in full once i go and click
restore down and the maximize then it will display in full.
How can I get the browser window to maximize on initial page load? Just to be
clear, I mean specifically the kind of maximize that happens when you press the
I am missing something here. I want to stop next page navigation from
showing if there are less than 25 records over all. This is what I
have.
Page
Show All
I thought I would right it this way; it does disappear, but doesn't
matter how many records there are.
Maybe something like this (which I cannot test):
SELECT
c.id,
c.name,
i.*
FROM
customer c
LEFT OUTER JOIN
(
-- Get max (most recent) id (assuming pkey) of
-- each invoice as grouped by client.
Thanks for getting back to me buddy,
Looks as if all my woes were caused by a spelling mistake, my fault for
making a variable name so damn long, I has setOutgoingServer() but
getOutogingServer().
All sorted now and my contact forms working a charm,
Thanks,
Rob
-Original Message-
From:
I didn' t actually, since I don't use JPG for chart images - I like
the look of the flash charts better. On the Linux boxes where I use
the JPG charts, I haven't had a problem. Have you played with the
various file formats?
I was just applying hotfixes and since I use cfchart, I figured "
Greetings,
Have a general question about XML/XSLT and CF. One of the powers that be is
making noises about limiting the use of CF etc., etc., etc. One of the
arguments he's using is that XML/XSLT can handle most data display.
Unfortunately I know know enough about XML/XSLT to discuss the issue
Folks,
I'd like to know what you're using for lower-end *hardware* load
balancing for your ColdFusion apps. I've got an application to deal
with that doesn't have a lot of network bandwidth but does have a lot
of processor load, so I don't need a paired set of BIGIPs to manage it
:)
I'd prefer a
Just testing, I have not received any cf-talk since last night at around
8:30 pdt.
~|
Deploy Web Applications Quickly across the enterprise with ColdFusion MX7 &
Flex 2
Free Trial
http://www.adobe.com/products/coldfusion/flex
I have decided to abandon using Flash Forms for this stuff since it is
starting to get suckey. I am going back to HTML/Tables.
--
Bruce Sorge
"I'm a mawg: half man, half dog. I'm my own best friend!"
~|
Deploy Web Applicatio
Jake,
Did you ever get this resolved? I am having the same problem.
Thanks, Jeff
~|
Upgrade to Adobe ColdFusion MX7
The most significant release in over 10 years. Upgrade & see new features.
http://www.adobe.com/products/coldfus
removing the DISTINCT did the trick.
Thank you both.
Josh Nathanson wrote:
> I don't think you need DISTINCT at all if you are using GROUP BY. GROUP BY
> will group all the matching rate values together automatically, so the
> result will be all distinct values. Try something like (not tes
having brain fart here ... ughh
scenario: customer table, invoice table
I'd like to do a query to list the last invoice for each customer.
Can someone point me in the right direction please?
TIA,
Jenny
~|
ColdFusion MX7 by A
Thanks Neil,
We have this code across quite a few of our applications and don't really have
the time to start changing it all at the moment. That's why I thought I'd ask.
Cheers,
James
~|
ColdFusion MX7 by Adobe®
Dyncamically t
I first looked into this and than we decided to simply run authentication
over SSL to protect our services. In our situation, the amount of
development didn't justify the end result.
We also found that even with the Java upgrade to allow the Encrypt tag more
functionality, we had problems as .NET
56 matches
Mail list logo