Dennis,
Yes, you can connect CF to a remote MSDE database. Use the SQL Server ODBC
connector to do so, not MS Access. MSDE is basically SQL Server 7 with a 2gb
size limitation minus the enterprise manager. Access 2k has it's own
"enterprise manager" for MSDE, but you'll need to create a project (
I've got some experience with the Sonicwalls - both the SonicWall XPRS2 and
the higher end VX. You get great bang for the buck - they are solid
products. But if you need to do anything sophisiticated, like authentication
by port, you're going to need something a bit more powerful - like
Checkpoint
Yes - go into the CF Administrator, click on LOCKING from the menu on the
left. Towards the bottom of the scree you'll see the different locking
options. Select AUTOMATIC READ LOCKING for Application, Server or Session
variables. A couple of months ago there was some discussion regarding this
topi
Marius,
Here's some sample code. I'm dumping the WDDX packet into a client variable
which is used in another frame.
Basket=StructNew();
rc=StructInsert(Basket, "Item", "#Trim(getPartInfo.item_no)#");
rc=StructInsert(Basket, "Description", "#Trim(getPartInfo.item_desc_1)#");
rc=StructInsert(Bask
Try this:
Category'))>
-Original Message-
From: bfalloon [mailto:[EMAIL PROTECTED]]
Sent: Thursday, April 05, 2001 9:05 AM
To: CF-Talk
Subject: CFSETTING "HTML Strings" *URGENT*
Hello,
Can someone help me with this problem?
I want to create a string that contains HTML. Specifically a
Try something like this:
- Original Message -
From: "Jason Egan" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Tuesday, April 03, 2001 1:54 PM
Subject: verity and pdf's
> In a PDF document (office documents as well) you can set document
> information - description, autho
>
- Original Message -
From: "P@tty Ayers" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Tuesday, April 03, 2001 9:45 AM
Subject: Displaying yes/no field dynamically in checkboxes
> Friends,
>
> I would much appreciate any help with a problem I'm stuck on.
>
> I'm writing
to arrive.
>
> having used it can you please give me your independent assestment of the
> product ?
>
> Thanks
>
> -Original Message-
> From: Chris Michl [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, February 22, 2001 3:39 PM
> To: CF-Talk
> Subject: Re: Web Mining,
Jason,
You could buy Access 2k and run MSDE rather than JET. MSDE is basically SQL
Server 7 sans the Enterprise Manager. You can create triggers, stored
procedures, views etc., and except for the 2gb limit, it scales okay. I
understand there are no licensing issues beyond owning a copy of Access
Dave,
If you are using SQL Server 7 (or better yet, SQL Server 2000), Knosys
(http://www.knosysinc.com) makes a nice product called ProClarity. I've just
started deploying it in the past couple of weeks. It has the ability to
create web-based views of an OLAP cube and it also has a plug-in for
Mi
Yes there is. I use it all the time and it works fairly well. You can take a
look at the Pervasive website for more info: http://www.pervasive.com.
Regards,
Chris
- Original Message -
From: "Simon Halcrow" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Monday, January 15, 200
You can filter out system tables in Enterprise Manager by right clicking on
the server name and then selecting "Edit SQL Server Registration
Properties". Uncheck "Show system databases and system objects."
Chris
- Original Message -
From: "Joe Sheble aka Wizaerd" <[EMAIL PROTECTED]>
To: "
Just a comment: I thought I'd take a look at a couple of the "high" profile
sites mentioned that have not not plugged the htr.dll calls. In light of the
other ongoing discussions here regarding the use of CFLOCK, it is
interesting to note that some of these sites do not use locking on their
sessio
Jeff,
Connecting to Pervasive can sometimes be, well, interesting. You've got to
be very careful about .dll mismatches between the client, ODBC in this case,
and the server engine. I'd recommend running the CLEANUP utility from
Pervasive -- it does a really good job of removing all remnants of t
Do you have your clause flip-flopped?
Where '#URL.FileID#' = JobInfoUpload.FileID
Should be:
Where JobInfoUpload.FileID='#URL.FileID#'
- Original Message -
From: "Chad Gray" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, November 30, 2000 10:51 AM
Subject: UPDAT
It may be the fact that you're now using CFHTTP instead of CFX_HTTP. Many of
us have experienced similiar problems with CFHTTP -- do you use it quite
heavily on your site? I've switched all of my CFHTTP calls over to ASPHTTP
(www.serverobjects.com), a COM object you can access with CFOBJECT. There
You could scan the documents and save them in PDF format. If you include
Keywords in the PDF file, you can use Verity/CF to do the searching and
display of the documents.
Regards,
Chris
- Original Message -
From: "Joseph J. Sanger, M.D." <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED
SELECT TextFieldOne + ' ' + TextFieldTwo AS CombinedTextfield
- Original Message -
From: "Darin Cosgrove" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Friday, October 06, 2000 4:42 PM
Subject: combining text fields inside query
> Can anyone tell me if this is legal?
>
>
I'm jumping into the middle of this, but are you by chance comparing one
NTFS drive to another using FAT??? FAT drives won't carry the same
permission options as an NTFS drive.
- Original Message -
From: "Dave Watts" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTEC
Take a look at Voloview:
http://www3.autodesk.com/adsk/section/0,,231612,00.html
-Original Message-
> From: Michael Gagnon [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, September 21, 2000 9:18 AM
> To: CF-Talk
> Subject: OFF topic - Autocad images
>
>
> Hi!
>
> Is there an application
Sim,
Try using the CreateODBCDate function in your WHERE clause:
WHERE YourDate = #CreateODBCDate(Now())#
Chris
-Original Message-
From: Sim Graves [mailto:[EMAIL PROTECTED]]
Sent: Thursday, September 14, 2000 10:25 PM
To: [EMAIL PROTECTED]
Subject: Just Today
I feel so stupid askin
Ben,
In answer to your question regarding CFHTTP under CF 4.51... forget about
it. I'm now using a COM object called ASPHTTP (from www.serverobjects.com)
within my CF scripts. It is rock solid -- the only downside is that it does
not permit HTTPS.There is another COM object, ASPTEAR, that also ha
away with new
perspectives that I wouldn't have understood if I had stayed home -- and I
think I'm a more valuable developer/employee as a result. I'll be attending
this year's conference with the same expectations.
Regards,
Chris Michl
- Original Message -
From: "
ncorrect to admit that you use Access, but it is
an inexpensive solution that can be a good fit in some situations -- plus it
is relatively easy to upsize to SQL Server when you can justify the cost.
Chris Michl
- Original Message -
From: "Gregory Harris" <[EMAIL PROTECTE
would be interested in that also Chris...
>
> Jim
>
> -Original Message-
> From: Chris Michl
> To: [EMAIL PROTECTED]
> Sent: 29/08/00 5:01 PM
> Subject: Re: ASPHTTP as COM Object
>
> John,
>
> If you do not need SSL, I DO have
That is also my understanding; nevertheless, CFHTTP is unsafe to use under
even moderate load.
Chris
- Original Message -
From: "Neil H." <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, August 29, 2000 4:46 PM
Subject: Re: ASPHTTP as COM Object
I was under the impression that
John,
If you do not need SSL, I DO have sample code of ASPHTTP implemented use
CFOBJECT...
Chris Michl
- Original Message -
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, August 29, 2000 3:33 PM
Subject: RE: ASPHTTP as COM Object
> We haven't us
One alternative would be to use MSDE (Access 2000), which is really SQL
"Lite". You stiil have stored procedures, triggers, views, etc -- you just
don't get the enterprise manager. Instead the DB is managed through an
Access interface.
Regards,
Chris Michl
- Original Mes
duct), I am aware
it has some limitations - namely a timeout function that works properly. The
timeout function, something I desperately need in my applications, appears
to work flawlessly in ASPHTTP.
Hope this helps s
Protofax is an inexpensive, reliable solution that works well for me.
http://www.protonet.com/efax/cf_fax.htm
Regards,
Chris
- Original Message -
From: "Adrian Cesana" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, August 16, 2000 3:45 PM
Subject: faxing again
> Ive seen
You're halfway there. Map the datasource in the NT ODBC Datasource manager.
Now go under SERVICES on the Cold Fusion server. Ensure that CF is logging
in using a Domain account that has full permissions to the Access DB on the
target server. CF is probably currently configured to use the LOCAL SYS
I'm curious to know what people are using for requirements management tools.
I wouldn't mind hearing the ballpark costs for the tool if you happen to
know.
Thanks,
Chris
--
Archives: http://www.mail-archive.com/cf-talk@h
There are instances where you may need to store BLOBs, however. For example,
we have a VB application that builds custom layout drawings, along with some
HTML, on the fly. These drawings are *always* peculiar to a specific quote
for a specific customer. The VB app inserts the BLOBs into a table th
Clinton,
I presume you're talking about IIS 4. If so, here are a couple of links:
General Microsoft Checklist for IIS security:
http://www.microsoft.com/security/products/iis/CheckList.asp
Remove the EVERYONE group from your server, but make sure the permissions in
the link below are granted to
There are a couple of CFX tags for inserting and retrieving images for SQL
Server and Access: Get_Image.dll and Put_Image.dll. They should be available
in the Allaire tag gallery.
Chris
- Original Message -
From: "Patrick Maddox" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, A
Marcus,
Yes - I work with Pervasive quite a bit. One thing you have to watch when
doing INSERTs is using ";" to terminate your statement. For example:
INSERT INTO MyTable(MyColumn)
VALUES('MyData');
won't work. Are you actually using the brackets around your list of columns?
Otherwise, I've hav
A couple of references I quickly looked up:
http://support.microsoft.com/support/kb/articles/Q178/6/50.ASP
and
http://forums.allaire.com/DevConf/Thread.cfm?&&Message_ID=282578
- Original Message -
From: "Dave Wilson" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, August 0
Is your DB Access by chance? If so, there are problems running that
configuration...I don't happen to have any references at my fingertips,
however.
Chris
- Original Message -
From: "Jim Mixon" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, August 02, 2000 9:39 AM
Subject: C
When you turn on debeugging, what do you show for URL parameters being
passed?
- Original Message -
From: "Ray, James A" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, July 27, 2000 10:51 AM
Subject: Wierd Query Error
> CAn anyone tell me if there is something wrong with thi
Go into the Management Console and bring up the properties for your target
website. Select the HOME DIRECTORY tab and the click on the CONFIGURATION
button on the lower right side of the window. You'll see a list of file
associations -- notice the mapping for CF. Add an entry (or modify an
existi
You could add wild cards to LIKE:
select id, entered_date, synopsis, knowledge
from nxsknow
where knowledge = '%#search_string#%'
order by entered_date desc
- Original Message -
From: "miles" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, July 12, 2000 12:23 PM
Subj
This article at ZDLabs states that single CPU Win2k servers perform about
the same as single processor NT 4 machines. A performance boost comes in
multi-processor configurations, and in a new disk swapping algorithm. It
looks like the focus of the review may be more on file serving than on
applica
For those of you who need to know...
==
Dear UPS OnLine(r) Tools Registrant:
UPS is continuing to develop its family of UPS OnLine Tools in ways that
allow you
to maximize your e-commerce strategies.
With this in mind, we have updated our Rates and Service Selection tool.
James,
Use the TITLE attribute to do this.
Regards,
Chris
- Original Message -
From: "James Taavon" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, June 28, 2000 1:13 PM
Subject: Equivalent
> I know this is not a CF question, but it does apply to the CF App I am
> develop
Hi Stew,
Maybe I'm waving the white flag too early, and your security folks may not
go for it, but have you considered running your web box on the INSIDE of the
firewall?
Regards,
Chris
- Original Message -
From: "Stewart McGowan" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednes
Move the BODY variable like this:
#body#
- Original Message -
From: "Gregg Kachel" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, June 27, 2000 12:26 PM
Subject: Textarea
> Hi, I'm sort of a newbie with Cold fusion, so I'm probably doing some
> simple mistake. I can't get
You could do it this way:
selected>#i# week/year
Regards,
Chris
- Original Message -
From: "Erika Foster" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, June 27, 2000 9:24 AM
Subject: Selecting a value in a dropdown.
> I am populati
Use # to escape (also remember to escape your BGCOLOR). For example:
##variable
Regards,
Chris
-Original Message-
From: Dan Cameron [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, June 21, 2000 8:47 PM
To: [EMAIL PROTECTED]
Subject: escaping special characters between
This is most
As far as I know, the only thing you can extract are the keywords. Here's
what I use:
Regards,
Chris
- Original Message -
From: "Parker, Kevin" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, June 21, 2000 1:29 AM
Subject: RE: Searchy thing
> Thanks Paul - does anyone kn
A couple of different ways that immediately come to mind:
1. Using your existing query:
select masterID
form MasterTable
where SignUpDate = #SignUpDate#
DELETE FROM MasterTable
WHERE masterID=#GetMasterID.masterID#
- OR -
DELETE FROM MasterTable
WHERE masterID IN (#G
50 matches
Mail list logo
