I know this is probably simpler than I'm making it, but I have Table A with two
different references to the primary key in table B.
Table A
===
From To
==
1 2
2 4
3 7
Table B
===
PK Firstname Lastname
== =
1 John Doe
2 Jane Doe
3
Solution I received from BACFUG member Jim Flannery:
This should work in MS-SQL:
SELECT sender = sentfrom.firstname + ' ' + sentfrom.lastname,
receiver = sentto.firstname + ' ' + sentto.lastname
FROM TableA
INNER JOIN TableB sentfrom ON TableA.From = sentfrom.PK
I'm actually on a computer without any serverware right now to test this out
but I think you can do something like:
select ta.*, tb1.*, tb2.*
from tableA ta, tableB tb1, tableB tb2
where ta.from = tb1.pk and ta.to = tb2.pk
On Wed, May 20, 2009 at 1:20 AM, Marie Taylore mt4yl...@yahoo.com
You'll obv want to give the * fields aliases to be able to access them more
easily.
On Wed, May 20, 2009 at 1:26 AM, David McGuigan davidmcgui...@gmail.comwrote:
I'm actually on a computer without any serverware right now to test this
out but I think you can do something like:
select ta.*,
The converted image is missing the JPEG identifier (it should have
JFIF somewhere at the start of the file according to
http://en.wikipedia.org/wiki/JFIF)
~|
Want to reach the ColdFusion community with something they want? Let
I have a simple input field the dynamically retrieves data from Oracle and
populates other input fields.
I am using keyup on the binding. This is working okay EXCEPT that when using
firefox (possible IE as well), firefox has cached the previous data I entered
on the field.
e.g. I I entered
I set up a form to identify the character, but the square doesnt paste.
When I opened the orig file of the phone numbers in word it did list the
numbers on single lines so it may be a newline character.
My Loop must be wrong, it's only passing one value, any suggestions would be
most
Hi,
My application will involve generating transaction ID's and I would love to
generate them in sequential order. What is the best way to do this?
Also I would appreciate any pointers to the best practice in generating
transaction ID's
it will surely depend on how and where you are going to be using those
generated transaction ids...
Azadi Saryev
Sabai-dee.com
http://www.sabai-dee.com/
On 20/05/2009 19:31, Fawzi Amadu wrote:
Hi,
My application will involve generating transaction ID's and I would love to
generate them in
On Wednesday 20 May 2009, Fawzi Amadu wrote:
Also I would appreciate any pointers to the best practice in generating
transaction ID's
Inside an application or server level lock would seem obvious.
--
Helping to preemptively accelerate error-free revolutionary distributed
e-tailers as part
Within the loop you want to use the variable i (your index)... That will be
the variables that holds one phone number at a time.
Also, I think you want to use try delimiters=#chr(10)##chr(13)#,
Lastly, I can't tell if you really put the file upload with that form right
before the loop (or if
http://en.wikipedia.org/wiki/Identity_column
On Wed, May 20, 2009 at 7:31 AM, Fawzi Amadu abd...@gmail.com wrote:
Hi,
My application will involve generating transaction ID's and I would love to
generate them in sequential order. What is the best way to do this?
Also I would appreciate any
cf's bindings to form controls do not allow for event chaining or
binding to multiple events...
so, save for turning FF's autocomplete feature off by adding
autocomplete=off to your form/cfform tag, you are out of luck...
Azadi Saryev
Sabai-dee.com
http://www.sabai-dee.com/
On 20/05/2009
I know there are plenty of tags out there that strip/convert high ascii to low
ascii - usually on the front end through form input or whatever.
The problem I'm encountering is this: I'm using CFHTTP to grab a page that has
content with high ascii smart quotes, apostrophes, em dashes, etc.
I'm dealing w/ a corrupt SQL Server master DB right now, so all my SQL Server
sites are offline at the moment (ugh) -- but that's not why I'm here.
While trying to figure out what in heck was going on on my server I looked at
Task Manager processes and sorted by various columns until I saw the
At 07:35 PM 5/19/2009, you wrote:
The error logging throttle needs some work (tries to prevent duplicate
error emails, etc.), but overall, I'm liking this approach mucho.
I gave up on emailing myself every error message. I use gmail and
it was refusing mail because I was getting too many.
Have you played with charset, The character encoding of the request,
including the URL query string and form or file data, and the response.
http://livedocs.adobe.com/coldfusion/8/htmldocs/Tags_g-h_09.html#3989287
On Wed, May 20, 2009 at 8:35 AM, John Drake thedangerman...@yahoo.comwrote:
I
I would use a stored procedure which just adds 1 to a value in the
database, updates the database and returns the number (inside a transaction)..
however, you have to be careful with sequential numbers. If you are
using them on a website, explore what happens if you change the
number to the
I got some feedback from the IEBlog team.
They say that this is a regression in IE8 related to an obscure but valid
JPEG type that has it's colour channels stored in a different order than the
more common format.
Not sure what a regression means though. Ie. do they consider it a bug or
not.
Michael,
Page faults occur when the memory manager is asked for a register that is
not in PHYSICAL memory (meaning it has been swapped to the disk. The word
fault was an unfortunate choice by some original assembly programmer
because it makes folks think something is wrong when it may or may not
Mark,
Thanks. That explained everything very well. I now know what to do.
Mik
Typically if you see a high rate you need more memory or you need to fine
tune the memory and processes that are running. In the case of JRUN and
MSSQL on the same machine (not a great idea but common) - as well as
BTW, I have 2gb on the machine already. Is it worth bumping
up to 3 or 4? I know that at one point Windows couldn't
address more than 2gb of ram, but I think that's no longer
the case, though it is for CF (unless CF8 can now address
more than 2gb?).
32-bit Windows itself can address 4GB
John,
That worked perfectly - thank you! The default for CFHTTP is UTF-8 and
changing it to windows-1252 gives me what I needed.
~|
Want to reach the ColdFusion community with something they want? Let them know
on the House
Michael,
It's not strictly true that windows can't address more than 2gb. Windows
cannot address more than 2gb of contiguous memory address space. That
certainly affects the JVM to be sure because the JVM needs contiguous space
to run. But you CAN make use of more than 2GB on a 32gb windows
OK...just so we are all on the same sheet of music here...I am including the
missing page template in this discussion as neither of them are working.
my directory structure:
D:\sites\cares10\online\misc\displayerror.cfm (missingPage.cfm is also
located in this directory). Online is the web
Sorry... That should have read ...make use of 2GB on a 32bit windows
box
-Mark
-Original Message-
From: Mark Kruger [mailto:mkru...@cfwebtools.com]
Sent: Wednesday, May 20, 2009 12:49 PM
To: cf-talk
Subject: RE: (ot) Page Faults
Michael,
It's not strictly true that windows can't
Thanks Ian...I will give that a try.
Ericf
On Wed, May 20, 2009 at 12:16 PM, Ian Skinner h...@ilsweb.com wrote:
Eric Roberts wrote:
OK...just so we are all on the same sheet of music here...I am including
the
missing page template in this discussion as neither of them are working.
The
Eric Roberts wrote:
OK...just so we are all on the same sheet of music here...I am including the
missing page template in this discussion as neither of them are working.
The most consistent way I have been able to work with custom templates
for the site-wide error handler and missing template
On Wed, May 20, 2009 at 7:33 PM, Michael Muller wrote:
BTW, I have 2gb on the machine already. Is it worth bumping up to 3 or 4?
Not if it is Windows Webserver Edition, which is limited at 2 GB.
Jochem
--
Jochem van Dieten
http://jochem.vandieten.net/
True... That is worth mentioning.
But... The web edition will not run MSSQL - so I don't think that is the
edition he is using.
-mark
Mark A. Kruger, CFG, MCSE
(402) 408-3733 ext 105
www.cfwebtools.com
www.coldfusionmuse.com
www.necfug.com
-Original Message-
From: Jochem van Dieten
BTW, I have 2gb on the machine already. Is it worth bumping up to 3 or 4? I
know that at one point Windows couldn't address more than 2gb of ram, but I
think that's no longer the case, though it is for CF (unless CF8 can now
address more than 2gb?).
Mik
I should know better by now but does anyone know of a cold fusion tag for
interfacing with the Twitter API that... wait for it ... works in Cold
Fusion 5.x?
I know about the ColdFusion Twitter Lib at RIAForge however it is a CFC and
will not operate on CF5. Pathetic I know but that is what the
For Coldfusion 5, I'd just use basic authentication, not oAuth.
For newer versions of CF, use oAuth. Let me know if you need help with this
- I've got it working.
On Wed, May 20, 2009 at 1:03 PM, UXB Internet denn...@uxbinternet.comwrote:
I should know better by now but does anyone know of a
basic authentication
To be more specific, you can use plaintext REST calls to interact with the
Twitter API. The only difference is you have to ask people for their
Twitter passwords, which they might not want to divulge.
On Wed, May 20, 2009 at 1:31 PM, Philip Kaplan pkap...@gmail.com wrote:
I'm looking to document our codebase. I'd like to use the documentation format
that Java uses (http://java.sun.com/javase/6/docs/api/), Coldbox uses
(http://www.coldboxframework.com/api/), and others... First off - what's the
name of that documentation format? Secondly - I know someone has put
ColdDoc by Mark Mandel: http://colddoc.riaforge.org/ or CFCDoc by
Spike, myself, and Jax (http://cfcdoc.riaforge.org/). ColdBox uses
the latter.
cheers,
barneyb
On Wed, May 20, 2009 at 3:35 PM, Jake Pilgrim jpilg...@snapfitness.com wrote:
I'm looking to document our codebase. I'd like to use
On Wed, May 20, 2009 at 7:46 AM, Al Musella, DPM wrote:
At 07:35 PM 5/19/2009, you wrote:
The error logging throttle needs some work (tries to prevent duplicate
error emails, etc.), but overall, I'm liking this approach mucho.
I gave up on emailing myself every error message. I use gmail
Thanks, I found the problem. I use standard edition but need to use enterprise
one.
On mine, it's CF Admin Event Gateways Gateway Instances.
I can not find CF Admin Data Services Event Gateways Gateway
Instances option in my local CF admin panel.
Is there anything that i need to
38 matches
Mail list logo