Autobytel.com is pretty stinkin big. They're CF.
-Original Message-
From: Emmet McGovern [mailto:[EMAIL PROTECTED]
Sent: Friday, December 17, 2004 12:00 PM
To: CF-Talk
Subject: large cf ecom sites?
I have a client that is starting to backpedal on wanting to use
coldfusion
for their
Just do a SELECT DISTINCT...
-Original Message-
From: Stuart Kidd [mailto:[EMAIL PROTECTED]
Sent: Monday, December 06, 2004 4:16 PM
To: CF-Talk
Subject: Re: Joins
Hi, I'm getting an error with both your reply and Michaels so I don't
know
if it's something I explained incorrectly.
I'm
For high traffic and easily modifiable code, nothing compares to Netready.
Check it out:
http://www.cfnetready.com http://www.cfnetready.com
+---+
Bryan Love
Database Analyst
Macromedia Certified Professional
Internet Application Developer
mr_message_id = 10132 AND mr_user_id =
'Mitch' AND mr_result = 4 AND tpines.message_to_recipient.mr_recipient_id =
T1.recipient_id) )!---Query String ends ---') WHERE
tbl_CampaignMgrActionData.ActionID = 68
f
+---+
Bryan Love
Database Analyst
Macromedia Certified
tbl_CampaignMgrActionData.ActionID = 68
The DB thinks that the single quote in front of Mitch marks the end of the
string, that's why you need to let CF escape it before sending it to the DB.
+---+
Bryan Love
Database Analyst
Macromedia Certified Professional
Internet
Check out the new website for Netready:
http://cfnetready.com/ http://cfnetready.com/
And as part of our kickoff for this website, we'll sell our software for
$200 to anyone who mentions this message through the end of August!
+---+
Bryan Love
.id = t2.id
WHERE t2.id IS NULL
(Oracle)
SELECT t1.id
FROM table1 t1, table2 t2
WHERE t1.id = t2.id(+) AND t2.id IS NULL
+---+
Bryan Love
Database Analyst
Macromedia Certified Professional
Internet Application Developer
TeleCommunication Systems
the times I've seen someone do that, over 90% of them could have been
avoided by structuring the logic differently.
+---+
Bryan Love
Database Analyst
Macromedia Certified Professional
Internet Application Developer
TeleCommunication Systems
[EMAIL
+---+
Bryan Love
Database Analyst
Macromedia Certified Professional
Internet Application Developer
TeleCommunication Systems
[EMAIL PROTECTED]
+---+
...'If there must be trouble, let it be in my day, that my
QBOS_HELPFILE
WHERE keywordsLIKE '%#word1#%' OR keywordsLIKE '%#word2#%'... etc...
+---+
Bryan Love
Database Analyst
Macromedia Certified Professional
Internet Application Developer
TeleCommunication Systems
[EMAIL PROTECTED
Now session.myform points to the same struct as form and you won't lose
it.
+---+
Bryan Love
Database Analyst
Macromedia Certified Professional
Internet Application Developer
TeleCommunication Systems
[EMAIL PROTECTED
.
+---+
Bryan Love
Database Analyst
Macromedia Certified Professional
Internet Application Developer
TeleCommunication Systems
[EMAIL PROTECTED]
+---+
...'If there must be trouble, let it be in my day, that my child may have
Yes, it's written in ColdFusion.
+---+
Bryan Love
Database Analyst
Macromedia Certified Professional
Internet Application Developer
TeleCommunication Systems
[EMAIL PROTECTED]
+---+
...'If there must
pid=19
+---+
Bryan Love
Database Analyst
Macromedia Certified Professional
Internet Application Developer
TeleCommunication Systems
[EMAIL PROTECTED]
+---+
...'If there must be trouble, let it be in my
I'd recommend Authorize.net.I've integrated Authorize.net, SkipJack, and
Verisign.Verisign is good, but their CF tag doesn't work, so I had to use
COM to integrate it into my shopping cart.SkipJack is also good, but more
restrictive than AuthNet.Authorize.net allows the ability to pay by ECHECK
if
I don't know for sure if you can search *LOBs, but I know you can search
TEXT fields... have you thought about whether or not you can use a TEXT
field instead?You might already know about this, but in case you don't:
They are called ConText indexes... and the creation of them looks
something like
IS NOT NULL AND talents ''
3) now you can run queries like this:
SELECT *
FROM [table]
WHERE talents LIKE '%,#aTalent#,%'
+---+
Bryan Love
Database Analyst
Macromedia Certified Professional
Internet Application Developer
TeleCommunication Systems
You could cheat and use WDDX - it converts structures to XML and back
again...
+---+
Bryan Love
Database Analyst
Macromedia Certified Professional
Internet Application Developer
TeleCommunication Systems
[EMAIL PROTECTED
.
+---+
Bryan Love
Database Analyst
Macromedia Certified Professional
Internet Application Developer
TeleCommunication Systems
[EMAIL PROTECTED]
+---+
...'If there must be trouble, let it be in my day, that my child may have
peace'...
- Thomas
.
+---+
Bryan Love
Database Analyst
Macromedia Certified Professional
Internet Application Developer
TeleCommunication Systems
[EMAIL PROTECTED]
+---+
...'If there must be trouble, let it be in my day, that my child may have
peace
The client scope is NOT a struct ;)
+---+
Bryan Love
Database Analyst
Macromedia Certified Professional
Internet Application Developer
TeleCommunication Systems
[EMAIL PROTECTED]
+---+
...'If there must
Just curious... why are you using a two-dimensional array? Why not just use
a normal array and make all the odd indices questions and all the even
indices answers?
+---+
Bryan Love
Database Analyst
Macromedia Certified Professional
Internet
simply change the action variable and cause a new page
to display in the
second switch.
|| HISTORY ||
Author: Bryan Love ; [EMAIL PROTECTED] ; 2/1/01
|| VARIABLES ||
- variables.fuseAction
|| END FUSEDOC ||
---
!---### action switch
I totally agree with you regarding FuseBox 3, but the older FuseBox
architectures were simpler and far more easy to learn/understand/implement.
I've written many apps using FB2-ish architecture and they absolutely fly
when it comes to performance and I've gotten a lot of positive feedback from
cfset total = totalRecs + myquery.totalRecs[i-1]
#AGY# #FUND# #Total# #totalRecs#br
/cfloop
+---+
Bryan Love
Database Analyst
Macromedia Certified Professional
Internet Application Developer
TeleCommunication Systems
[EMAIL
+---+
Bryan Love
Database Analyst
Macromedia Certified Professional
Internet Application Developer
TeleCommunication Systems
[EMAIL PROTECTED]
+---+
...'If there must be trouble, let it be in my day, that my child may have
peace
First of all, why are you doing it? Why store the whole thing in memory?
+---+
Bryan Love
Database Analyst
Macromedia Certified Professional
Internet Application Developer
TeleCommunication Systems
[EMAIL PROTECTED
Mary Jo, I hope the work on converting CFWebstore to FB is successful, I
won't ever need another CF e-commerce app again!
Why not try NetReady? It's already done in Fusebox and has an impressive
feature list... Since the last update of the web page below there have been
a few other additions,
It's been too long since I incorporated a good forums application. Anyone
have any suggestions? If it's configurable then I don't care too much how
it's written, but if it's not, then I much prefer something in FB2 - NOT
FB3.
Bryan Love
depends entirely on what DB you are using, whether or not you want it to be
searchable, and what you want the max allowable size to be.
+---+
Bryan Love
Database Analyst
Macromedia Certified Professional
Internet Application Developer
on Windows you can check the registry:
CFREGISTRY ACTION=GETALL NAME=DS_ODBC_List
TYPE=ANY BRANCH=HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\ODBC Data
Sources
cfset DSNnames = valueList(DS_ODBC_LIST.entry)
here ya go - here's an example:
cfset w = 0
cfset x = NEQ
cfset y = 1
cfif evaluate(#w# #x# #y#)hi/cfif
+---+
Bryan Love
Database Analyst
Macromedia Certified Professional
Internet Application Developer
TeleCommunication Systems
[EMAIL PROTECTED
post the code you are using to create the array of structs from the query
results.
+---+
Bryan Love
Database Analyst
Macromedia Certified Professional
Internet Application Developer
TeleCommunication Systems
[EMAIL PROTECTED
to get the list of campuses and another to display the
information about a chosen campus, right? That's how CF was meant to work
best.
+---+
Bryan Love
Database Analyst
Macromedia Certified Professional
Internet Application Developer
#
#selectCampuses[idx]
.
/cfoutput
+---+
Bryan Love
Database Analyst
Macromedia Certified Professional
Internet Application Developer
TeleCommunication Systems
[EMAIL PROTECTED]
+---+
...'If there must
What type of DB?
+---+
Bryan Love
Database Analyst
Macromedia Certified Professional
Internet Application Developer
TeleCommunication Systems
[EMAIL PROTECTED]
+---+
...'If there must be trouble, let
I can write you a custom tag if you want...
-Original Message-
From: James Johnson [mailto:[EMAIL PROTECTED]
Sent: Thursday, June 26, 2003 7:59 PM
To: CF-Talk
Subject: Creating a CF Data Source with CF Code - Possible?
Hello,
I'm creating an application where trusted users can upload
What version of MySQL are you using? Try switching to 4.1 if you aren't
using it...
http://www.mysql.com/doc/en/Charset-Unicode.html
+---+
Bryan Love
Database Analyst
Macromedia Certified Professional
Internet Application Developer
)
.
+---+
Bryan Love
Database Analyst
Macromedia Certified Professional
Internet Application Developer
TeleCommunication Systems
[EMAIL PROTECTED]
+---+
...'If there must be trouble, let it be in my day, that my child may
+---+
Bryan Love
Database Analyst
Macromedia Certified Professional
Internet Application Developer
TeleCommunication Systems
[EMAIL PROTECTED]
+---+
...'If there must be trouble, let it be in my day, that my child may have
peace'...
- Thomas
My mistake, I was reading up on the differences in unicode handling between
4.0 and 4.1 and I had 4.1 on my mind.
Jochem is correct, you would not want to use 4.1.
Good lookin' out, Jochem!
+---+
Bryan Love
Database Analyst
Macromedia Certified
you might try checking for the existence of the CALLER scope.
cfif isdefined(caller) AND isStruct(caller)
this template was called using CFMODULE
cfelse
this template was called using CFINCLUDE
/cfif
+---+
Bryan Love
Database Analyst
Macromedia
will start a fire? ;)
+---+
Bryan Love
Database Analyst
Macromedia Certified Professional
Internet Application Developer
TeleCommunication Systems
[EMAIL PROTECTED]
+---+
...'If there must be trouble, let
Who is to say JSP does it right? Personally, I love having my URL/Form
scopes split.
Amen to that!
+---+
Bryan Love
Database Analyst
Macromedia Certified Professional
Internet Application Developer
TeleCommunication Systems
[EMAIL PROTECTED
mentioning
the second one, and to them I say there is a time and place for everything
;)
+---+
Bryan Love
Database Analyst
Macromedia Certified Professional
Internet Application Developer
TeleCommunication Systems
[EMAIL PROTECTED
doubt that switching will make any difference one way or
another. Maybe your problem is DB related - maybe not - but it almost
certainly is not related to your choice of ODBC or OLE drivers.
+---+
Bryan Love
Database Analyst
Macromedia Certified
.
+---+
Bryan Love
Database Analyst
Macromedia Certified Professional
Internet Application Developer
TeleCommunication Systems
[EMAIL PROTECTED]
+---+
...'If there must be trouble, let it be in my day, that my child may have
peace'...
- Thomas Paine
+---+
Bryan Love
Database Analyst
Macromedia Certified Professional
Internet Application Developer
TeleCommunication Systems
[EMAIL PROTECTED]
+---+
...'If there must be trouble, let it be in my day, that my child may have
peace
??? As far as I know you can't put bold and italics in a text area.
+---+
Bryan Love
Database Analyst
Macromedia Certified Professional
Internet Application Developer
TeleCommunication Systems
[EMAIL PROTECTED
to keep track manually.
+---+
Bryan Love
Database Analyst
Macromedia Certified Professional
Internet Application Developer
TeleCommunication Systems
[EMAIL PROTECTED]
+---+
...'If there must be trouble, let
there are.
+---+
Bryan Love
Database Analyst
Macromedia Certified Professional
Internet Application Developer
TeleCommunication Systems
[EMAIL PROTECTED]
+---+
...'If there must be trouble, let it be in my day, that my child may have
peace'...
- Thomas Paine
is failing. Most likely the cookies aren't being
set and/or transmitted. Did the domain name change?
+---+
Bryan Love
Database Analyst
Macromedia Certified Professional
Internet Application Developer
TeleCommunication Systems
[EMAIL PROTECTED
for that. Two queries is not that
big a deal. It's when you put queries inside loops that you deserve to be
shot ;)
+---+
Bryan Love
Database Analyst
Macromedia Certified Professional
Internet Application Developer
TeleCommunication Systems
[EMAIL PROTECTED
on
+---+
Bryan Love
Database Analyst
Macromedia Certified Professional
Internet Application Developer
TeleCommunication Systems
[EMAIL PROTECTED]
+---+
...'If there must be trouble, let it be in my day, that my child may have
peace'...
- Thomas
','BROCCOLI')
ORDER BY Description
/cfquery
+---+
Bryan Love
Database Analyst
Macromedia Certified Professional
Internet Application Developer
TeleCommunication Systems
[EMAIL PROTECTED
item from the file.
Put structNew inside the for loop and each iteration of the list will give
ad a new memory pointer and each array item will be unique.
+---+
Bryan Love
Database Analyst
Macromedia Certified Professional
Internet Application
;)
+---+
Bryan Love
Database Analyst
Macromedia Certified Professional
Internet Application Developer
TeleCommunication Systems
[EMAIL PROTECTED]
+---+
...'If there must be trouble, let it be in my day, that my
(LoginArray[ArrayRows][2],client.UserID)
!--- delete array row code goes here ---
cfset arrayDeleteAt(LoginArray,ArrayRows)
cfbreak
/cfif
/cfloop
+---+
Bryan Love
Database Analyst
Macromedia Certified Professional
Internet
)
cfset trash = arrayAppend(x,y)
/cfloop
+---+
Bryan Love
Database Analyst
Macromedia Certified Professional
Internet Application Developer
TeleCommunication Systems
[EMAIL PROTECTED
Anyone know how to access MS Outlook's calendar using CF? I assume there is
an object I can tap, but I don't know what it would be...
+---+
Bryan Love
Database Analyst
Macromedia Certified Professional
Internet Application Developer
nevermind, found it in the houseoffusion archives after a lengthy search :)
+---+
Bryan Love
Database Analyst
Macromedia Certified Professional
Internet Application Developer
TeleCommunication Systems
[EMAIL PROTECTED
#)
.
+---+
Bryan Love
Database Analyst
Macromedia Certified Professional
Internet Application Developer
TeleCommunication Systems
[EMAIL PROTECTED]
+---+
...'If there must be trouble, let it be in my day
.
+---+
Bryan Love
Database Analyst
Macromedia Certified Professional
Internet Application Developer
TeleCommunication Systems
[EMAIL PROTECTED]
+---+
...'If there must be trouble, let it be in my day, that my child may have
peace'...
- Thomas
ahh, then the second suggestion will still work - putting caller. in front
of the query name.
+---+
Bryan Love
Database Analyst
Macromedia Certified Professional
Internet Application Developer
TeleCommunication Systems
[EMAIL PROTECTED
is the
same for the http site and the https site and perhaps that will fix it.
+---+
Bryan Love
Database Analyst
Macromedia Certified Professional
Internet Application Developer
TeleCommunication Systems
[EMAIL PROTECTED
don't know about CFMX, but in other versions of CF you need the full path to
the jvm.dll. This is what I have and it works:
Java Virtual Machine Path
c:\jre\1.2\bin\classic\jvm.dll
+---+
Bryan Love
Database Analyst
Macromedia Certified
query
/cfquery
/cftransaction
cfcatch
oops
/cfcatch
/cftry
+---+
Bryan Love
Database Analyst
Macromedia Certified Professional
Internet Application Developer
TeleCommunication Systems
[EMAIL PROTECTED
try it and see :)
+---+
Bryan Love
Database Analyst
Macromedia Certified Professional
Internet Application Developer
TeleCommunication Systems
[EMAIL PROTECTED]
+---+
...'If there must be trouble, let
What DB are you using? Oracle8i has a neat function named initcap that will
do it for you. You could say:
SELECT INITCAP(LOWER(city)) as city FROM someTable...
+---+
Bryan Love
Database Analyst
Macromedia Certified Professional
Internet
Just have a pre-page pop up that asks them if they are a competitor.
Problem solved.
just kidding :)
+---+
Bryan Love
Database Analyst
Macromedia Certified Professional
Internet Application Developer
TeleCommunication Systems
[EMAIL PROTECTED
An excellent choice!
+---+
Bryan Love
Database Analyst
Macromedia Certified Professional
Internet Application Developer
TeleCommunication Systems
[EMAIL PROTECTED]
+---+
...'If there must be trouble
be there.
+---+
Bryan Love
Database Analyst
Macromedia Certified Professional
Internet Application Developer
TeleCommunication Systems
[EMAIL PROTECTED]
+---+
...'If there must be trouble, let it be in my day, that my child may have
peace
time you insert a
record you set all other records in that category to 0 and set the new one
to 1. Then your query just says:
SELECT ...
FROM table1
WHERE mostRecent = 1
+---+
Bryan Love
Database Analyst
Macromedia Certified Professional
you could do something like this...
cfdirectory directory=#expandPath([virtual directory])#
+---+
Bryan Love
Database Analyst
Macromedia Certified Professional
Internet Application Developer
TeleCommunication Systems
[EMAIL PROTECTED
the loop
once and record the results to a string, then use the string in 4 or 5
different places
+---+
Bryan Love
Macromedia Certified Professional
Internet Application Developer
Database Analyst
TeleCommunication Systems
[EMAIL PROTECTED
ORDER BY name
+---+
Bryan Love
Macromedia Certified Professional
Internet Application Developer
Database Analyst
TeleCommunication Systems
[EMAIL PROTECTED]
+---+
...'If there must be trouble, let
.
+---+
Bryan Love
Macromedia Certified Professional
Internet Application Developer
Database Analyst
TeleCommunication Systems
[EMAIL PROTECTED]
+---+
...'If there must be trouble, let it be in my day, that my child may
to investigate just how much RAM and disk space SQL Server is allowed to
consume.
I've also seen CFX tags that caused a server to stop responding sometimes.
Are you using any of these?
+---+
Bryan Love
Macromedia Certified Professional
Internet Application
original question:
1. Jerry is correct about placing commas before and after the list in the
DB - it is a must.
2. CONTAINS is a CF function, not SQL. You must use LIKE.
+---+
Bryan Love
Macromedia Certified Professional
Internet Application
The GUI should not allow you to choose to be the mainteacher for students
who already have one... It seems to me that the error lies in the GUI and
should be fixed there, not behind the scenes.
+---+
Bryan Love
Macromedia Certified Professional
make sure when you put values in the seeking column to add a comma before
and after the list. So a list of 1,2,3 becomes ,1,2,3,
That way when you run the query you can say:
WHERE seeking LIKE '%,2,%'
+---+
Bryan Love
Macromedia Certified
The most obvious thing is that the cfset... should be inside the cfif...
you should also use form[strImage#i#New] instead of evaluate.
+---+
Bryan Love
Macromedia Certified Professional
Internet Application Developer
Database Analyst
Has anyone had issues using CFMX with an ACCESS client storage database? A
friend of mine is getting 500 Operation failed on the data source named
'client_storage'.
This only seems to happen using CFMX...
+---+
Bryan Love
Macromedia Certified
Does it validate from the CF Administrator?
+---+
Bryan Love
Macromedia Certified Professional
Internet Application Developer
Database Analyst
TeleCommunication Systems
[EMAIL PROTECTED
timeout.
+---+
Bryan Love
Macromedia Certified Professional
Internet Application Developer
Database Analyst
TeleCommunication Systems
[EMAIL PROTECTED]
+---+
...'If there must be trouble, let it be in my day
select *
from sometable
where substr(somecolumn,1,1) BETWEEN '0' AND '9'
+---+
Bryan Love
Macromedia Certified Professional
Internet Application Developer
Database Analyst
TeleCommunication Systems
[EMAIL PROTECTED
directly if you look for
it...
+---+
Bryan Love
Macromedia Certified Professional
Internet Application Developer
Database Analyst
TeleCommunication Systems
[EMAIL PROTECTED]
+---+
...'If there must be trouble
would still
execute.
+---+
Bryan Love
Macromedia Certified Professional
Internet Application Developer
Database Analyst
TeleCommunication Systems
[EMAIL PROTECTED]
+---+
...'If there must be trouble, let
and retrieve data using Java so I know the issue is with CFMX.
+---+
Bryan Love
Macromedia Certified Professional
Internet Application Developer
Database Analyst
TeleCommunication Systems
[EMAIL PROTECTED
tt.emp_ID_nr IS NULL
+---+
Bryan Love
Macromedia Certified Professional
Internet Application Developer
Database Analyst
TeleCommunication Systems
[EMAIL PROTECTED]
+---+
...'If there must be trouble, let
content
WHERE keywordIDs LIKE '%,23,%'
AND keywordIDs LIKE '%,12,%'
/cfquery
+---+
Bryan Love
Macromedia Certified Professional
Internet Application Developer
Database Analyst
TeleCommunication Systems
[EMAIL PROTECTED
)
But CFMX is doing something that causes it to be displayed funky after
retrieval even though it looks fine when I look directly in the DB.
Anyone know why??? Anyone?
+---+
Bryan Love
Macromedia Certified Professional
Internet Application Developer
one at a time...
I suspect there is a bug in the way that CFMX is converting the byte array
to a string.
Can anyone confirm or deny this?
+---+
Bryan Love
Macromedia Certified Professional
Internet Application Developer
Database Analyst
Why not just set up replication between the databases to keep them in sync?
+---+
Bryan Love
Macromedia Certified Professional
Internet Application Developer
Database Analyst
TeleCommunication Systems
[EMAIL PROTECTED
it looks to me like you shouldn't be looking in
C:\Inetpub\wwwroot\cfide\classes\cfjava.cab
but rather in
C:\Inetpub\wwwroot\cfide\classes\CFJava2.jar
+---+
Bryan Love
Macromedia Certified Professional
Internet Application
:
[execute some code]
break;
}
+---+
Bryan Love
Macromedia Certified Professional
Internet Application Developer
Database Analyst
TeleCommunication Systems
[EMAIL PROTECTED
You can't.
You must use replace() to replace the comma/space with a single character
that you can use as the delimiter. The bell character works well since it
can't be typed (chr(7)).
+---+
Bryan Love
Macromedia Certified Professional
Internet
I highly recommend using CFINCLUDE in a situation like this. It's much
simpler.
Have your form submit to some action page that simply does this:
CFINCLUDE template=../#form.fiscalyear#/#form.statecode#.cfm
+---+
Bryan Love
Macromedia Certified
sorry, had to do it!
+---+
Bryan Love
Macromedia Certified Professional
Internet Application Developer
Database Analyst
TeleCommunication Systems
[EMAIL PROTECTED]
+---+
...'If there must be trouble
AND steel.method_id = method.method_id
AND lookup.type_id IN (Select type_id from lookup where
lookup.type =
'#form.steeltype#')
/CFQUERY
+---+
Bryan Love
Macromedia Certified Professional
Internet Application Developer
Database
1 - 100 of 558 matches
Mail list logo