A recruitment web site we are working on is looking into a content sharing
agreement with a large portal.
Essentially we want to publish brief job listing details (job title,
company name, brief description) on the portal which then link back to a
co-branded page or display our content on
I am using SQL 2000, and as per the docs, I should be able to create
Full-text indexes on MS Word docs stored in image columns.
Just to test this, I created a new table, and used the TEXTCOPY application
to add around 20 rows in it, one word document per row.
The table schema is as follows :
My coldfusion web application uses a SQL 2000 DB on Win 2K server.
Presently, we are storing resumes of registered candidates in our database,
the table being used has the following design :
USER_ID int 4
ENTRY_DATE datetime8
I am currently evaluating FuseTalk version 3.1 on my development
environment, which is CF 4.5.1 SP2 with IIS5 on Win 2K Server, and SQL 2000 DB.
I followed their instructions and set up FuseTalk to work with SQL 2000 DB,
and using 'External User Database' and 'External Authentication Method',
Has anybody experienced this problem with the ColdFusion Scheduler ? I am
not using cfschedule, just have created the schedule to run daily in
ColdFusion Administrator. It's a highly database-intensive process, which
dynamically generates and sends out daily email alerts.
9 times out of 10,
Can somebody advise me on a good SQL Server forum, where I may get some
help on my query performance optimisation issues ? I have tried posting on
the forums at www.sqlmag.com, http://www.sqlteam.com and
http://www.swynk.com, but no response on any of these. They do not appear
to be very
Our SQL 2000 DB runs on a Win 2K Server, which is a PIII, 500 MHz machine,
having 512 MB RAM and 30 GB Hard Drive.
There is an application that searches for keyword matches in our database,
and calls a stored procedure to perform the actual query. The tables being
used are small, approx
Has anyone else experienced these missing form data errors ? These are not
due to improper bookmarking, or due to browser having JavaScript disabled.
The form field exists, but on submittting, is somehow not available to the
next page. These occur randomly, and therefore cannot be a coding
Recently, my ColdFusion application.log has started showing a few messages
like this:
Error,TID=1060,08/28/02,09:42:04,CFSCHEDULE,unknown exception
conditionP PCodeRuntimeContextImp::executeSQLTagCFQuery::endTagpThe
error occurred while processing an element with a general identifier of
I've been having frequent problems with a mailing schedule that I've set up
in ColdFusion Administrator. It is quite database intensive, has a fair bit
of string manipulation, and involves generating around 3 - 5K emails daily.
Nowadays, more and more frequently, I find the execution hangs in
I've been having frequent problems with a mailing schedule that I've set up
in ColdFusion Administrator. It is quite database intensive, has a fair bit
of string manipulation, and involves generating around 3 - 5K emails daily.
Nowadays, more and more frequently, I find the execution hangs in
Some further analysis shows that at the same time that the error was logged
in my coldfusion server application.log file, there was also an entry in my
Win 2K server's event viewer application.log file :
Event Type: Information
Event Source: DrWatson
Event Category: None
Event ID:
My webserver.log file shows the following message :
Error,TID=1652,08/18/02,08:37:42,Web server provided content data
when none was expected. Data ignored.
Does anyone know what this means ? We are running CF 4.5 SP2 with IIS 5 on
WIN 2K Server, and SQL 2000 DB.
Vishal.
Has anybody experienced this problem with the ColdFusion Scheduler ? I am
not using cfschedule, just have created the schedule to run daily in
ColdFusion Administrator. It's a highly database-intensive process, which
dynamically generates and sends out emails.
9 times out of 10, it runs fine,
I saw a post on this forum regarding a cfexecute problem where if you:
(1) Don't specify an output file
(2) Get a long output from your executable then you get a hung process on
your server.
Has anybody experienced a similar problem with the ColdFusion Scheduler ? I
am not using cfschedule,
I saw a post on this forum regarding a cfexecute problem where if you:
(1) Don't specify an output file
(2) Get a long output from your executable then you get a hung process on
your server.
Has anybody experienced a similar problem with the ColdFusion Scheduler ? I
am not using cfschedule,
I have my site developed in ColdFusion. I need to integrate this with a
message forum application written entirely in ASP. I need to pass session
information from my .cfm templates to the message forum. Essentially, if a
person is logged in on the site, they should be logged in on the forum as
Can anybody recommend a good freeware message forum written purely in
ColdFusion ? It should be possible to integrate it with a SQL 2000 DB.
Has anyone evaluated or is using FuseTalk (http://www.e-zonemedia.com/) ?
Any comments ?
Vishal
I have a form with a number of text and textarea fields. Information
submitted is then written to a SQL Server Database. I want to prevent users
from typing in potentially malicious javascript in any of these fields.
One option is to loop through all the submitted form variables before
I have a form with a number of text and textarea fields. Information
submitted is then written to a SQL Server Database. I want to prevent users
from typing in potentially malicious javascript in any of these fields.
One option is to loop through all the submitted form variables before
In one of my stored procs, I have a query that performs a keyword search
(keywords are always strings) on many columns, and returns the resultset.
The query is as folllows:
SELECT a.cnd_id, a.cnd_update_date
FROM candidatemaster a inner join candidateresume b on a.cnd_id = b.cnd_id
WHERE
Our site has around15-20 different e-mails (all dynamically generated) that
are triggered off based on different user actions, such as registration,
unsubscribing etc. All the e-mails on our site are being sent out using one
single template, i.e. the template is called using cfmodule with an
CFX_POP3 is a freeware that is supposed to take care of the problems with
CFPOP.
I have written a coldfusion template that uses CFX_POP3 to log into an
external POP server and download the header information. This has been
scheduled to run every 15 minutes. Most of the time, it works as
We attempted to upgrade our development server - which is running CF4.5 and
SQL2000 on a Win 2K Server to CF5 . On completing the installation and
doing the configuration settings as described in the documentation, we are
unable to view the ColdFusion Administrator or any other templates. In
Is there any way I can get the list of tables in a SQL 2000 DB
programmatically ? I guess what I need is a limited form of sp_help, as
long as it just gives me all the user-created tables, system tables not
required.
Vishal.
We are using CFPOP to log into an external POP server and download the
header information.
CFPOP SERVER=mail.mycompany.net USERNAME=myusername PASSWORD=mypassword
ACTION=GetHeaderOnly NAME=Sample
CFOUTPUT QUERY=Sample
I am currently running CF 4.5 SP2 with IIS5, Win 2K Server and SQL 2000 DB.
I plan to upgrade to CF5. Would anyone like to share their experiences on
having performed a similar upgrade ?
What we really need are suggestions for a migration plan to help us move
over smoothly to the new version
I found on the Allaire Developer's Exchange a custom tag called
createtable_Access, which allows me to create a table in any MS Access ODBC
datasource accessible through ColdFusion, in which we can define Primary
Key, Required fields (Not Null), and Unique values.
What I need is a SQL Server
Our ColdFusion Logs show pages getting timed out - it seems to happen at
times of high traffic. We would like to be able to troubleshoot the source
of the problem.
We have set the max number of simultaneous requests in ColdFusion
Administrator to 15. Supposing we have a 16th simultaneous
Does anyone know of any custom tags /applications that allow importing data
from :
1. CSV files
2. Excel Spreadsheets
3. MS Access
into one of the following formats:
1. Ms Access
2. SQL 2000
Yes, I know that we can do this directly in Excel, Access and SQL 2000
itself. But I want to be able
We have created an online assessment on our site, in some ways similar to
the BrainBench online tests. It is a dynamic page and it submits back to
itself. We use a JavaScript function to work as a timer - the countdown is
shown in the bottom status bar.
window.status=Time left = + counter +
We are using CF4.5 with IIS5 on W2K server and SQL 2000 DB for our website.
I have a big problem with users getting random errors about missing
parameters - either form data or url parameters. The required form fields
are validated for using javascript, which ensures that the problem is not
page (at the top),
just to make sure you are in fact getting the
fieldnames.
- Original Message -
From: Vishal Narayan [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Wednesday, April 10, 2002 8:42 PM
Subject: CF - Problem with missing Form Data
We are using CF4.5 with IIS5 on W2K
page (at the top),
just to make sure you are in fact getting the
fieldnames.
- Original Message -
From: Vishal Narayan [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Wednesday, April 10, 2002 8:42 PM
Subject: CF - Problem with missing Form Data
We are using CF4.5 with IIS5 on W2K
34 matches
Mail list logo
