I'm glad that the final implementation seems to have gone
from having the
browser transfer the data, to having the Flash client request
the data from
the server directly... seems like it would avoid all those browser
dependencies.
/me is looking forward to inherent and easy handling of
I've Just spoken to our resident Ingres expert, and his opinion is that you
need to use a DB procedure to do it.
Jason Lees
National Express
Email : [EMAIL PROTECTED]
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: 15 May 2001 18:37
To: CF-Talk
Subject:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Dear all
I'm running NT 4 SP5 with CF 4.5.1 SP2, Spectra 1.0.1 and PWS.
If I upgrade to Windows 2000 Professional with IIS 5, are there any
precautions I should be aware of? I tried searching thru this list and
Allaire KB, but found nothing.
We found that the CF Adv Security services would fail unless upsized from
the default Access DBs on Win2k/IIS5.0. Apart from that, things seem to be
running smoothly. But, of course, you wouldn't run Adv Security through
Access DBs anyway :)
Morten O.
-BEGIN PGP SIGNED MESSAGE-
Hash:
FYI, the first line is superfluous as CGI vars are special in that they will
always exist, including made up names like cgi.happy_hovercraft. In fact,
cgi vars afaik are r/o so cfparaming them would be pointless.
Steve
-Original Message-
From: another programmer [mailto:[EMAIL
we use shopcreater, www.shopcreator.com , it works :)
Stew
-Original Message-
From: Christine Kelley [mailto:[EMAIL PROTECTED]]
Sent: 15 May 2001 20:03
To: CF-Talk
Subject: E-commerce Dilemma
Hi!
I need to implement an e-commerce package for one of my
sites, but I haven't worked
Check out http://www.wilk4.com/asp4hs/
Justin
-Original Message-
From: Kay Smoljak [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, May 16, 2001 5:45 AM
To: CF-Talk
Subject: Scripting The Visual Tools Object Model
Hi all,
I have been trolling through the Studio docs to find info on
Am getting there...
For the uninitiated:
CF-Talk Archiver is a ColdFusion application for retrieving CF-Talk email
messages and storing them in a database for indexing. The application
fetches the emails from the email address you subscribed to for CF-Talk
email messages. It doesn't handle
David,
You might be better off setting up an Intranet License to distribute it
yourself -- check out this page:
http://www.macromedia.com/support/shockwave/info/licensing/main_3.html
Tim P.
- Original Message -
From: David Shadovitz [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Has someone experince the SQL full text search mechanisem
with ColdFusion? Is it possible to send regular FullText Queries
(i.e CONTAINS and FREETEXT code) and display results
EFFICIENTLY? or should I use some other method (for displaying,
not searching - SQL Full Text is the mechanisem I want to
Flash player should be included with most apps, try browsing the CD's of
your apps - say Dreamweaver, Studio, CF etc...
N
!-
Neil Clark
Senior Web Applications Engineer
Spectra / ColdFusion / XML / Cerebro
MCB Digital
Macromedia Alliance Member
Tel: 020 8941 3232
Hey all,
I'm using CFREPORT for the first time, and it's driving me batty.
The report I'm trying to access is on a different server than my calling
template (not running CF on that server), and it has the Crystal Reports Web
Component Service installed. (We want the reports to be served via a
Can I do a select * from company_table then join it to the slow, medium
and fast tables ?
I tried something similar using both inner , outer and full joins yesterday
and kep being told that it could not find some of the fields.
-Original Message-
From: Bob Silverberg [mailto:[EMAIL
Actually it is a one to one relationship.
There is only one set of tables per company name.
-Original Message-
From: John [mailto:[EMAIL PROTECTED]]
Sent: 15 May 2001 17:38
To: CF-Talk
Subject: RE: SQL Joins.
I am guessing this is a one to many relationship between company_table and
Cool thanks, I will give it a go
-Original Message-
From: John Wilker [mailto:[EMAIL PROTECTED]]
Sent: 15 May 2001 17:34
To: CF-Talk
Subject: RE: SQL Joins.
You could use INNER JOINs if each table has a company ID for sure.
FROM company_table INNER JOIN slow_stream ON slow_stream.ID
Post the code you tried yesterday and we'll have a look.
--
Andrew Ewings
Project Manager
Thoughtbubble Ltd
http://www.thoughtbubble.net
--
United Kingdom
Could I possibly get a copy too ?
Much appreciated.
Darren Adams
Web Developer
Marketing Department
Systems Union
Office: 01252 55 6220
Mobile: 07714 817 038
Email: [EMAIL PROTECTED]
-Original Message-
From: Derek Hamilton [mailto:[EMAIL PROTECTED]]
Sent: 16 May 2001 05:36
To: CF-Talk
I would do but it a fit of frustration I deleted it and just used some cf
locations to previously written pages.
I was mainly just doing it to experiment with joins, since it has been a
while since I have used them.
I'll give your code a whirl and see what I get.
Cheers,
-Original
we're in the process of moving everything from NT to Linux. i think one of
the major issues to note is what type of database server you're going to be
running. MySQL is good and so is the ODBC driver but you really need to
become familiar with command line. It isn't GUI driven like SQL server
* Team Allaire *
Has someone experince the SQL full text search mechanisem
with ColdFusion? Is it possible to send regular FullText Queries
yes. do it all the time.
(i.e CONTAINS and FREETEXT code) and display results
EFFICIENTLY? or
Last I looked you needed to become a partner of sorts of Macromedia to
download the installer (for inclusion on CD-ROMs, or use on an Intranet,
etc). All this required was filling out a license agreement which included
a requirement that you not distribute the package except as permitted.
Thanks
Norman
-Original Message-
From: Jason Lees (National Express)
[mailto:[EMAIL PROTECTED]]
Sent: Wednesday, May 16, 2001 3:58 AM
To: CF-Talk
Subject: RE: OpenIngres Database
I've Just spoken to our resident Ingres expert, and his opinion is that you
need to use a DB procedure to
How do we obtain this amazing product, please?
- Original Message -
From: Bryan Love [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Tuesday, May 15, 2001 12:55 PM
Subject: RE: E-commerce Dilemma
Check this out. It kills both of the carts you are looking at! I
personally know
Personally, I think the M$ books are too vague (rendering
them useless), and
a waste of money. The best book I've come across (and has since been
referred to as the bible)
is Transact-SQL Programming from O'Reilly. It covers MS SQL 7 and
certainly
has more than just T-SQL.
Thanks for
Hi Guys
i have an issuse please help.
i have a select menu where i select multiple select to insert
the code is
select name=team_member size=4 multiple
option value=0/optioncfoutput query=qry_get_team_members
option
On 5/15/01, Robert Long penned:
Tell him to go to www.google.com and type in .cfm and tell
you how many records are returned.
Hi. He doesn't dispute that .cfm pages can be indexed, only that
robots will not follow links with a .cfm extension.
--
Bud Schneehagen - Tropical Web Creations
* Team Allaire *
Has someone experince the SQL full text search mechanisem
with ColdFusion? Is it possible to send regular FullText Queries
yes. do it all the time.
That's great to hear! are you simply using CFQUERY with the
For a non-coldfusion based one which works amazingly well have a look at
www.actinic.com
It provides an extremely good order management backend as well as a
reasonable front-end. The client will love you for providing good order
management.
-Original Message-
From: Christine Kelley
Wow! Sincere thanks to Brian, Tim, Neil, and another programmer (who
responded off-line).
I want to stay legit, so I'll probably go for a license rather than checking my
CD's. One potential stumbling block is that it looks like Macromedia has the
right to check out my intranet (item #7,
I use M$ full-text quite a bit. But I don't understand your question.
best, paul
At 02:06 PM 5/16/01 +0200, you wrote:
Has someone experince the SQL full text search mechanisem
with ColdFusion? Is it possible to send regular FullText Queries
(i.e CONTAINS and FREETEXT code) and display results
We have a custom designed program written in Lotus Notes at my
organization...
I have, on several occasions attempted to connect to the database (if you
really want to call it that) with little success.
I was able to extract information and present it to a webpage, but ANY
attempt to write back
Thanks everybody for the ideas and advice :)
Christine
- Original Message -
From: Christopher Olive, CIO [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Tuesday, May 15, 2001 1:50 PM
Subject: RE: E-commerce Dilemma
CFWebstore is EXCELLENT. Mary Jo has created an
It isn't GUI driven like SQL server and Access.
http://www.mysql.com/downloads/gui-clients.html
There is even an offical GUI.
I know there are third party clients but we haven't
had the chance
to test any.
Dont whine then :-)
m2d is very good, and the offical GUI is also very useful.
Everyone:
We have an application that uses session vars to track if the user is
logged in. Yesterday, the sessions started timing out after 10 - 15
seconds, even tho Application.cfm sets it at 20 minutes. Is it a
memory issue? Or should I look elsewhere? Just recently we set the
default Client
I am tired why is this giving me an error?
update ovdsave
set ovdsave.updatedate = getdate()
where ovdsave.sonum = (SELECT ovdtemp.SONUM
FROM ovdtemp)
and this way also gives me an error:
update ovdsave
set ovdsave.updatedate = getdate()
from (SELECT
Has anyone seen the CFStudio update to 4.5.2? It used to be
online, but now the link seems to be broken.
Thanks
Norman Elton
~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
At 09:50 AM 05/16/2001 -0400, you wrote:
We have a custom designed program written in Lotus Notes at my
organization...
I have, on several occasions attempted to connect to the database (if you
really want to call it that) with little success.
I was able to extract information and present it to a
Actually for MySQL connectivity, check out:
http://dajoba.com/projects/mysqltool/
The tool is PERL driven, and web-based, but by far it is the best tool for
mysql connectivity I have ever used. I got it up and running internally in a
matter of minutes, and I commonly edit the source code to add
Joel,
I had the exact same problem and my issue was memory -- we had an
application that crashed every now and then and would gobble up the memory,
stomping all over the CF session variables. I switched them to cookie based
client vars and that fixed it for me.
Tim P.
- Original Message
Joel:
Off the top of my head, I think a possible reason could be that cookies have
a certain limit in size (4K, if I am not mistaken), and if you have more
than that stored on a client's browser as a cookie, the system might not be
able to set the CFID as a cookie, therefore the session is lost.
Replace the = with IN in your where clause like so:
update ovdsave
set ovdsave.updatedate = getdate()
where ovdsave.sonum IN (SELECT ovdtemp.SONUM
FROM ovdtemp)
This is because SELECT ovdtemp.SONUM FROM ovdtemp returns more than 1
record
Joel,
I noticed the same problem and ended up reinstalling CF! I don't know
what the problem is and it seems like after a while my sessions start to
just shorten and shorten. If you find a solution please let me know.
Thanks,
Neil
- Original Message -
From: Joel Firestone [EMAIL
Two ways I can think of in 4.5x:
1) Keep the results on a per-user basis in session variables
2) Write a custom tag wrapper for CFSTOREDPROC that mimics CFQUERY's caching
abilities.
-Original Message-
From: Darren Nickerson [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, May 15, 2001 1:10 PM
Joshua, try:
update S
set S.updatedate = getdate()
FROM ovdsave S INNER JOIN ovdtemp T
ON S.sonum = T.SONUM
Then go home and get some sleep :)
Bob
-Original Message-
From: Joshua Tipton [mailto:[EMAIL PROTECTED]]
Sent: May 16, 2001 10:22 AM
To: CF-Talk
Subject: Update Statement
I am
I know this is Off Topic, but I've really spent the last day trying to find an answer
(my JavaScript skills are not that good, and I can not find a good resource/mailing
list to assist).
What I'm trying to do is populate two different text boxes, with different text, base
on the selection
check www.andamooka.org
-Original Message-
From: Angel Stewart [mailto:[EMAIL PROTECTED]]
Sent: Sunday, May 13, 2001 6:51 AM
To: CF-Talk
Subject: RE: Article Discussion ready solution
SIMPLEMESSAGEBOARD! :)
-Gel
-Original Message-
From: Fouad Al-Farhan [mailto:[EMAIL
-Original Message-
From: W Luke [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, May 16, 2001 1:34 PM
To: CF-Talk
Subject: Using 'Between' sql for Times/Dates
Hi,
I have a list of dates and times, in a field called logDate, which are
constantly updated. I need to pull the last 2 hours
Just to give you an example. I built a real estate site for someone. After
the main site was built he mentioned that for every neighborhood that an
agent
signs up for he wanted a discussion forum *sigh* so we already owned CF
Forum 2000
open source. I simply modified the source to create a new
-Original Message-
From: W Luke [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, May 16, 2001 1:34 PM
To: CF-Talk
Subject: Using 'Between' sql for Times/Dates
Hi,
I have a list of dates and times, in a field called logDate, which are
constantly updated. I need to pull the last 2
Does anybody have a reference of what database systems support SQL functions
like this?
Thanks in advance
Nathan Nelson
Cold Fusion Developer
..::[CFDynamics]::.
www.cfdynamics.com
[EMAIL PROTECTED]
(801)621-8511
* * You've got to check this out! * *
CFDCalendar
is logdate a date/time datatype?
W Luke [EMAIL PROTECTED] wrote:
That just pulled all the record, irrespective of time...I get the logic, but
not why it isn't working.
Hmmm.
- Original Message -
From: Alex [EMAIL PROTECTED]
Newsgroups: gradwell.lists.cftalk
Sent: Wednesday, May 16,
Does anyone else get an error upon closing cfstudio?
How do I fix it? :)
TIA,
jeff
~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives:
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Ray Bujarski [EMAIL PROTECTED] wrote:
If I want to decrypt a file that was encrypted with cf server, how would I
go about doing this?
Ray
~~
Structure your ColdFusion code with
Hi everyone.
Basically, I have a record set that returns a whole bunch of links, and
spits them out one to a table row, like so:
cfoutput query=qry_list_links
tr
td width=25 height=30nbsp;/td
tda href=http://#linkSiteURL#; target=_blank
font face=Verdana, Arial,
Na, don't give up control to CFTable -- you CAN do this, it is just a bit
trickier.
The following code will start a row for odd-numbered entries and close the
row after even numbered entries. Take a look:
cfoutput query=qry_list_links
cfif currentRow mod 2 is 1 !--- this is an odd row ---
tr
What version of Studio do you have?
I bet if you check out the Knowledge Base at Allaire.com, and search for the
error you are receiving you'll find a fix.
Some versions of Studio need patches, which can be download from Allaire.com
(and found through the Knowledge Base).
H.
Howard Owens
ya i just ignore it. as long as my pages dont get screwed i dont care!
Alexander Sicular
Chief Technology Architect
The Neurological Institute of New York
Columbia University
212.305.1318
as867 {at} columbia [dot] edu
-Original Message-
From: Jeff Green [mailto:[EMAIL PROTECTED]]
Sure, just use the Mod function to determine if you are the second column.
See code example below:
CFQUERY NAME=GetIDs DATASOURCE=DCContent
SELECT ID
FROMtblDLO
/CFQUERY
CFIF GetIDs.RecordCount
TABLE
TR
CFOUTPUT QUERY=GetIDs
Thanks. My guess was memory, tho the Linux box says the resources
are fine. Oh well.
J
Joel Firestone [EMAIL PROTECTED] wrote in message
3b028d3f$[EMAIL PROTECTED]">news:3b028d3f$[EMAIL PROTECTED]...
Everyone:
We have an application that uses session vars to track if the user is
logged in.
Encrypted with server? The only real way of encrypting server side is
using the decrypt() or cfusion_decrypt() functions ... This requires you
to know your key string. However, I think you're referring to .cfm
files encrypted with Studio. There's no official way to do it, unless
you contact
Ok heres the issue, i am sending out an HTML Form via email that is supposed
to post back to our server.
and i'm sure its something simple, but it gives this
An error occurred while evaluating the expression:
#attributes.companyname#
Error near line 5, column 10.
Bill, please post the code that threw the error. Let's see
qry_postcompanysurvey.cfm
We're not psychic! ;-)
-Original Message-
From: William J Wheatley [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, May 16, 2001 2:05 PM
To: CF-Talk
Subject: Email Forms
Ok heres the issue, i am sending
Does your cfparam tag look like this
cfparam name=attributes.companyname default=yourmama
or like this
cfparam name=companyname default=yourmama
the latter would fail as it is missing the attributes prefix. Just a stab
in the dark.
Brook
At 05:04 PM 16/05/01 -0400, you wrote:
Ok heres the
Howdy,
I am trying to get the CFINPUT Tag to validate an integer on a form. The darn tag
will validate SSN, zipcodes, etc, but when I enter the integer parameter and test the
validation using the following value ( .3 or any value that starts with a decimal
point ) the javascript validation
Hey, you could just use www.logiforms.com to create your survey.
cf_shameless plug
At 02:17 PM 16/05/01 -0700, you wrote:
Bill, please post the code that threw the error. Let's see
qry_postcompanysurvey.cfm
We're not psychic! ;-)
-Original Message-
From: William J Wheatley
Yes - General Date.
Any other ideas?
- Original Message -
From: Alex [EMAIL PROTECTED]
Newsgroups: gradwell.lists.cftalk
Sent: Wednesday, May 16, 2001 10:44 PM
Subject: Re: [Re: [Using 'Between' sql for Times/Dates]]
is logdate a date/time datatype?
W Luke [EMAIL PROTECTED] wrote:
There is an error in the javascript created by cfform
This is the function
function _CF_checkinteger(object_value)
{
//Returns true if value is a number or is NULL
//otherwise returns false
if (object_value.length == 0)
return true;
//Returns true if value is an
Hello,
Does anyone know how I can make the following code workI am trying to
use the DatePart Function to parse out the hour and minute from a date/time
field. however I am getting the hour in military time. To get around this
I thought I would subtract 12 from any hour 13 and
You can do this ALL with one function:
timeFormat(BeginTime,h mm)
The lower case h tells it to use 12 hr clock (use upper case for 24 hr)
(Note you don't have to say QRYCasacActivity.BeginTime because you are
inside a CFOUTPUT with query = QRYCasacActivity)
-Original Message-
From:
You're using CreateODBCTime() where you should be using
CreateODBCDateTime():
cfset twohours = CreateODBCDateTime(DateAdd(h, -2, now()))
Cfset nowtime = CreateODBCDateTime(now())
Your current code will only return the time part for comparison, not the
actualy date associated with the time.
On the subject of Forums, what Forum software is being used at
http://forums.allaire.com ?
best, paul
At 02:20 PM 5/16/01 -0400, you wrote:
Just to give you an example. I built a real estate site for someone. After
the main site was built he mentioned that for every neighborhood that an
agent
Thanks...that is exactly what I was looking for!!
Julie
From: Jann VanOver [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Subject: RE: manipulating DatePart Function???
Date: Wed, 16 May 2001 15:09:14 -0700
You can do this ALL with one function:
Matt,
Can I correct this js problem, or do I have to live with it?
Michael
- Original Message -
From: Jones, Matt [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Wednesday, May 16, 2001 4:58 PM
Subject: RE: CFINPUT -- not validating Integer
There is an error in the javascript
Instead of opening a new window, why don't you use an onUnload or
onBeforeUnload event in the body tag to close the session? This script from
MSDN worked in IE5.5 for me and supposedly it works in IE4+.
HTML
HEAD
SCRIPT
function closeIt()
{
// enter your close session script here
FUSETALK!
Awesome forum software :)
If you got the bucks, its the best money can buy.
www.fusetalk.com
-Gel
-Original Message-
From: Paul Smith [mailto:[EMAIL PROTECTED]]
On the subject of Forums, what Forum software is being used at
http://forums.allaire.com ?
best, paul
If you want to use CFINPUT, you have to live with it.
I found early on that I couldn't count on the CFFORM javascript and write
all my own Javascript validation code. You can find many examples on the
net, like http://irt.org
-Original Message-
From: Michael S. Kimmett [mailto:[EMAIL
Once again on the subject of Forums, I noticed that allaire forums are not
compatible with oracle. Does anyone know of any Oracle friendly forums
that are already developed that are for sale. My company would be very
interested in purchasing one as opposed to rebuilding a wheel.
Ray
At
just was curious if there are any issues with it, i have run into it before
=) its saying the varialbe is not there EVEN though its typed into the page
and hits the INDEX.CFM (fusebox style)
but this is not a fusebox questions (thats why its on Cf-talk) its a basic
is there anything special you
Fusetalk
http://www.fusetalk.com
### FROM http://www.e-zonemedia.com/fusetalk/mainfeat.cfm
FuseTalk currently supports four database platforms: Microsoft SQL Server
7/2000, MySQL, Oracle, and Microsoft Access.
###
-Original Message-
From: Ray Bujarski [mailto:[EMAIL PROTECTED]]
Sent:
Here is an experment that did and it works for IE, someone on the list may
have the equivilent for NS.
Here are the docs for all the char codes.
http://msdn.microsoft.com/workshop/author/dhtml/reference/charsets/charset1.
asp
Basicaly I just added an event to the input tag after it was loaded
Here is some Javascript that I use
Include this javascript in the form and
then use validate=checkInteger instead of validate=integer in your
cfinput tag
//Returns true if value is a number or is NULL
//otherwise returns false
function checkInteger(object_value) {
if (object_value.length ==
You might not have to live with it. If you use CFHTMLHEAD to write the correct
function, it will be used in lieu of the CF-generated function since it will
follow (and hence overwrite) the CF-generated one.
Not pretty, but it works.
-David
On Wednesday, May 16, 2001 3:49 PM, Jann VanOver
I'm currently re-query-ing Simple Message Board to work with Oracle. Not
entirely difficult.
Once again on the subject of Forums, I noticed that allaire forums are not
compatible with oracle. Does anyone know of any Oracle friendly forums
that are already developed that are for sale. My
What does this error message mean? I'm using an access database as an
interim measure with this project. The CFQUERY mentioned hasn't got
anything special in it .. this page is copied from another site that works
fine with identical setup - only the data itself is different. So I don't
think
* Team Allaire *
I haven't decided yet on which SQL version to use : 7 or 2000 (any major
diffrence?,
because money is an issue...)
sql server 2000's full text has quite a few nice improvements. we can't even
buy new sql server 7 here.
* Team Allaire *
CFQUERY datasource=xx name=xx
SELECT colum1,colum2
CONTAINS .
AND.
WHERE
/CFQUERY
CFQUERY datasource=xx name=xx
SELECT colum1,colum2
WHERE CONTAINS(*,'wheat beer') AND
86 matches
Mail list logo
