I am not sure what could be done however my sincere advice for the
future would be to use some source control system. There are plenty of
those out there which are free and quite easy to use. I would also
recommend Eclipse, which has its own local history of files, pretty
handy in such scenarios.
Here is a good book about CF List, Arrays and Structures
http://www.cafepress.com/protonarts.9983243
On Tue, 01 Feb 2005 11:51:07 -0500, Tim Laureska <[EMAIL PROTECTED]> wrote:
> I am rapidly coming to the conclusion that I need some educatin' with
> respect to structures, arrays, evaluation fun
Your variable difftype is not set for some case. I would first make
sure that 1,2,3,4 are the only values for lead_time_type_id
On Tue, 1 Feb 2005 16:39:24 +, Chris Kavanagh <[EMAIL PROTECTED]> wrote:
> Hi List,
>
> This CFSET is returning the error: "Variable DIFFTYPE is undefined."
>
> -
You can look at irt.org which has some nice tutorials on JavaScript.
http://developer.irt.org/script/cookie.htm
On Mon, 31 Jan 2005 21:36:04 -0500, Wurst, Keith D. <[EMAIL PROTECTED]> wrote:
> this is a little off topic but i didnt know where else to turn...
>
> im looking for a chunk of java
Have you looked into using XMLSearch function?
On Mon, 31 Jan 2005 10:38:16 -0800, Charles Heizer <[EMAIL PROTECTED]> wrote:
> Hello,
> I'm new to using XML parsing in coldfusion so I hope I'm phrasing this
> question properly. I was wondering if it's possible to query a xml doc
> and return all
Ian,
Here is my first stab even though I haven't tested it.
select a.*,
(select top 1 id from temp_image b where b.photographer =
a.photographer and b.id > a.id ) as nextid,
(select top 1 id from temp_image b where b.photographer =
a.photographer and b.id < a.id order by id desc )
I am having a bizzare problem as internet explorer is not submitting
any form elements. e.g I have a page like this
and the action page for form is
When I submit test.cfm using IE, on the action page nothing happens
and form variables do exists even in the debugging info of CF. However
th
the path was not found. Try wrapping the
> executable name with double quotes or try using the typical short name for
> program files (progra~1). Also, make sure that the path is correct :)
>
> HTH,
>
> Howie
>
> --- On Thursday, January 27, 2005 5:23 PM, Qasim
I am trying ti incorporate magictag by Algad for a client who is
currently running CF5. However it is giving me the following error.
Any help is greatly appreciated.
Error Diagnostic Information
ImageMagick execution produced an error.
Type: COM.ALLAIRE.COLDFUSION.CFEXECUTE.OUTPUTERROR
Message:
Have you tried using this
function checkUserInputs(form)
{
// One of the trials must be selected.
if(form.name.options[0].selected)
{
alert("Please select a trial.");
return false;
}
verify();
}
On Wed, 26 Jan 2005 14:44:22 -0500, Robert Orli
I guess you can use this function however be aware that it uses
undocumented cf service factory.
function verifyDatasource( dsn ){
return createObject('java',
'coldfusion.server.ServiceFactory').DataSourceService.verifyDataSource(
arguments.dsn );
}
On Wed, 26
have you tried something like this
select yourcolumns
from orders
group by yourcolumns
having sum(subtotal+shipping) = #form.totalchange#
On Wed, 26 Jan 2005 09:13:50 -0500, Che Vilnonis <[EMAIL PROTECTED]> wrote:
> This should be pretty easy for one of you SQL gurus out there...
>
> SELECT * F
You can use this function
Example usage
On Fri, 21 Jan 2005 16:05:11 -0500, Russ <[EMAIL PROTECTED]> wrote:
> How would I dump the current row that I'm outputting?
>
> For example:
>
>
>
>
How about using something like this "Less_than_12_years".
On Fri, 21 Jan 2005 15:07:31 -0600, Donna French <[EMAIL PROTECTED]> wrote:
> How can I avoid this so that it just evaluates as a string? Or is
> there a more efficient way to handle this SELECT?
>
> TIA,
> Donna
>
> On Fri, 21 Jan 2005
I have been using VSS plugin and so far it has been great on CFE.
On Fri, 14 Jan 2005 08:34:45 -0800, Spike <[EMAIL PROTECTED]> wrote:
> Robert Munn wrote:
> > Spike,
> >
> > Glad to see you are actively soliciting input. Here's my list:
> >
> > - A good data browser. Sean suggested DBEdit, I'll
Have you tried something like this
SELECT service_population,agency,city,state,salary_status
FROM internships
#preservesinglequotes( find_text )#
ORDER BY agency ASC
On Mon, 10 Jan 2005 13:10:06 -0500, Daniel Kessler <[EMAIL PROTECTED]> wrote:
> I'm doing my first Search utilit
Instead of this
use this
On Mon, 27 Dec 2004 19:12:36 -0800, Richard Colman <[EMAIL PROTECTED]> wrote:
> I seem to have a "sticky" application variable. How do I get it to change?
>
> The application.cfm file is:
>
> clientmanagement="Yes" SESSIONTIMEOUT="#CREATETIMESPAN(0,8,0,0)#" >
>
In addition to the suggestion that Dave made earlier, you can also
load Java classes remotely. Here is a link to a blog post by Christian
Cantrell on this technique.
http://www.markme.com/cantrell/archives/005295.cfm
On Thu, 23 Dec 2004 10:48:44 -0500, Dave Carabetta <[EMAIL PROTECTED]> wrote:
For those who work as a DBA or has to manage a SQL Server,
sql-server-performance has a great link to an article from Brian
Knight that discusses Disaster recovery and is "A Survival Toolkit for
the DBA". It even comes with a bunch of scripts already written.
Here is the link to the article
http:
try
On Wed, 22 Dec 2004 11:08:50 -0400, Asim Manzur <[EMAIL PROTECTED]> wrote:
>
>
> This is giving me the following error
>
> Parameter 1 of function IsDefined, which is now "form["Desc_ID1"]",
> must be a syntactically valid variable name.
>
>
~~
this error has nothing to do with eclipse infact I am sure it should
be giving you compile errors. Your code has various problems i.e
greetings not initialized, syntax error in for loop.
On Tue, 21 Dec 2004 11:05:34 -0500, Critter <[EMAIL PROTECTED]> wrote:
> I am just trying to build a simple c
Have you tried this UDF
http://cflib.org/udf.cfm?ID=556
On Tue, 14 Dec 2004 15:35:31 -0500, Tony Weeg <[EMAIL PROTECTED]> wrote:
> hola peoples
>
> has anyone used ryan emerle's query2csv custom tag? (or ryan if your
> listening)
>
> if so, can i disclude some columns? would i do that by spe
Why not just serialize it to wddx and pass that variable as hidden form field.
On Tue, 14 Dec 2004 11:31:34 -0500, Jerry Johnson
<[EMAIL PROTECTED]> wrote:
> Maybe?
>
>
> value="#queryname[field][1]#">
>
>
> Jerry Johnson
> Web Developer
> Dolan Media Company
>
> >>> [EMAIL PROTECTED] 12/14
www.web360software.com
On Thu, 9 Dec 2004 11:20:06 -0500, Mike Chabot <[EMAIL PROTECTED]> wrote:
> Does anyone know of a good Web-based time and attendance tracking system?
>
> This would be for a University that has exempt employees record when
> they are sick and when they are on vacation, not
use function preservceinglequotes if you are inserting those values in a DB
On Tue, 9 Nov 2004 11:29:31 -0500, Rick Faircloth
<[EMAIL PROTECTED]> wrote:
> When a user puts in Quotation Marks in a Textarea formfield
> the text gets cut off starting with the first quote...
>
> How can I avoid this
I tried this and it worked.
On Tue, 09 Nov 2004 11:20:41 -0400, Asim Manzur <[EMAIL PROTECTED]> wrote:
> |153564587|0|SAT|FREEDMAN|||1|||10/17/2004|10/18/2004
>
> I need to move all the valus in a into individual Structure/Array Keys. so I
> can display them individually.
>
> The abo
which db, what is the datatype of lines?
On Fri, 5 Nov 2004 14:34:46 -0600, Eric Creese <[EMAIL PROTECTED]> wrote:
> Can some one please tell me why this does not work? If you pass the url.inch
> variable it works fine. If you pass the url.line variable it fails with the
> following error. code
I am not sure about cffile or cfdirectory, however using some native
Java classes, I am confident that you can get this information.
On Thu, 4 Nov 2004 14:23:46 +1030, Parker, Kevin <[EMAIL PROTECTED]> wrote:
> Is it possible to determine the size of a file in CFML?
>
> TIA!!
>
> ++
>
I guess one option would be to create an array of structures for each
row of your getsearch query.
On Wed, 20 Oct 2004 23:31:41 -0400, Ben Densmore <[EMAIL PROTECTED]> wrote:
> I am running a query that pulls in a query string that is stored in a
> field in one of my tables. Thanks to some of t
www.web360software.com
On Wed, 20 Oct 2004 16:46:05 -0500, Russell Patterson <[EMAIL PROTECTED]> wrote:
> Hello,
>
> Would any one of you know of or recommend a good time & attendance ColdFusion module
> or app?
>
> Thanks!
> Russell
>
>
~
How about using
On Wed, 20 Oct 2004 13:27:10 -0500, Ben Densmore <[EMAIL PROTECTED]> wrote:
> I'm trying to find the best way to take a query string that would look
> something like name=somename&id=12&address=123&email=yes and pull
> out the values. These query strings are stored in a field
This might help you
http://cflib.org/udf.cfm?ID=993
On Tue, 12 Oct 2004 12:33:24 -0400, Duane Boudreau <[EMAIL PROTECTED]> wrote:
> Hi All,
>
>
> Has anyone written a routine to validate that all tags in a pseudo XML
> string are properly opened and closed? The strings aren't truly valid XML
>
CFCUnit.org and CFUnit in DRK are essentially two different products. AFAIK
On Tue, 12 Oct 2004 10:48:38 -0400, Joe Rinehart <[EMAIL PROTECTED]> wrote:
> Not sure, but you can get CFCUnit from http://www.cfcunit.org/ :)
>
> -joe
>
>
>
> On Tue, 12 Oct 2004 10:42:07 -0400, Dan O'Keefe <[EMAIL
if you have access to DRK, I remember there was a forum application in
some of it previous versions.
On Mon, 11 Oct 2004 09:31:51 -0400, Daniel Farmer <[EMAIL PROTECTED]> wrote:
> Looking to implement a public discussion forum... preferably free or low
> cost solution to plug into a client's site.
From October 18 - 29, Microsoft will offer a series of 40 live ASP.NET
developer training Webcasts. The Webcasts are free and anyone who
attends three or more can sign up to receive a free copy of Visual
Studio .NET 2003 Standard Edition and a book on ASP.NET development.
Details here www.aspnetwe
Britta,
I am glad that code sample helped. I will try to write a simple
example for you sometime tomorrow.
Thanks
Qasim
On Thu, 07 Oct 2004 21:49:27 -0400, Britta Bennett
<[EMAIL PROTECTED]> wrote:
> WOW! What a difference! This loads INSTANTLY, See
>
> http://realtorwebsites.ca/admin/CFX_XM
If you are on CFMX, here is an example for you. I think it will give
you a head start.
url="">
On Thu, 07 Oct 2004 19:46:08 -0400, Britta Bennett
<[EMAIL PROTECTED]> wrote:
> Hello Dave, Hello Paul..
>
> Yes, it being painfully slow is exactly the problem I'm encountering, this
> is why th
How does the xml file look like?
On Thu, 07 Oct 2004 16:36:33 -0400, Britta Bennett
<[EMAIL PROTECTED]> wrote:
> Ok, I've got the tag installed, now there's only one thing standing in my
> way:
>
> The xml data is dumped here:
> http://realtorwebsites.ca/admin/CFX_XMLParser/example.cfm
>
> The
You cannot rely on the order of struct keys as they can be in any
random orders. What i would suggest is to loop of StrutkeyList() or
StructKeyArray, after applying listsort or Arraysort respectively and
then output the results.
On Thu, 7 Oct 2004 13:14:50 +1300, Mark Henderson <[EMAIL PROTECTED]
Why don't you simply do this
SELECT ssn
FROM Import_Cap_Status
WHERE (Branch = 0001) AND (phase=2) \
AND ssn in (
SELECT DISTINCT b.ssn FROM faLoans a
INNER JOIN abIdentity b ON a.IdentityID = b.ID
INNER JOIN Import_Cap_Status c ON b.SSN = c.SSN
WHERE (c.Branch = 0001) AND (
http://cflib.org/udf.cfm?ID=686
- Original Message -
From: Michael Traher <[EMAIL PROTECTED]>
Date: Wed, 22 Sep 2004 22:58:10 +0100
Subject: Re: QueryString
To: CF-Talk <[EMAIL PROTECTED]>
depends on your connection method but many connection layers have
debug switches which allow you to
Can you try this
demographicvaluedesc LIKE ''%'[EMAIL PROTECTED]'%'' i.e without month. I think
single quote before % has to be escaped.
- Original Message -
From: Eric Creese <[EMAIL PROTECTED]>
Date: Wed, 22 Sep 2004 16:16:25 -0500
Subject: RE: SQL: Passing vars to a LIKE statement
To:
Jason,
If you didn't find a custom made function, I think you can take a look
at debug.cfm under C:\CFusionMX\wwwroot\WEB-INF\debug and get a head
start.
- Original Message -
From: Jason Reichenbach <[EMAIL PROTECTED]>
Date: Wed, 22 Sep 2004 17:27:38 -0400
Subject: RE: debug question
To:
How about this
http://gilgamesh-solutions.com/products.cfm#p1
- Original Message -
From: Brant Winter <[EMAIL PROTECTED]>
Date: Wed, 22 Sep 2004 15:00:32 +1000
Subject: RE: print output
To: CF-Talk <[EMAIL PROTECTED]>
Timeframe : 6 months ago - like everything else round here.
_
As far as I know you cannot.
- Original Message -
From: Tony Weeg <[EMAIL PROTECTED]>
Date: Wed, 22 Sep 2004 09:59:03 -0400
Subject: ot: sql question
To: CF-Talk <[EMAIL PROTECTED]>
is it true that we cannot use go in sql statements using cfquery?
--
tony
Tony Weeg
macromedia cert
Is there a reason that you do not use CFREPORT tag?
- Original Message -
From: julian @ b-ravestudio. com julian @ b-ravestudio. com
<[EMAIL PROTECTED]>
Date: Tue, 21 Sep 2004 13:01:31 -0400
Subject: CFX Tag no longer working - help!
To: CF-Talk <[EMAIL PROTECTED]>
Gretings all,
I have be
Hi Everyone,
Recently I installed XP SP2 on my machine and suddenly ColdFusion MX
is unable to connect to my SQL server present on the same machine. I
tried opening the port on Windows firewall and even disabling firewall
but it just won't connect.
Anyone has gone through similar situation or any
Farcry
- Original Message -
From: vishnu prasad <[EMAIL PROTECTED]>
Date: Mon, 20 Sep 2004 23:28:13 -0400
Subject: CMS
To: CF-Talk <[EMAIL PROTECTED]>
HI AlL
Is there is any Opensource CMS in Coldfusion ?
regards
Vishnu Prasad
[Todays Threads]
[This
] and
they dont cram everyone on one server so the bandwidth is always good
-- Original Message --
From: Sean Corfield <[EMAIL PROTECTED]>
Reply-To: [EMAIL PROTECTED]
Date: Mon, 20 Sep 2004 16:45:19 -0700
>On Mon, 20 Sep 2004 11:45:29 -0400, Qas
I knew this question has been asked several times and I searched
through the archives but couldn't find a good solution. Here is my
requirements any reocommendations, advice is appreciated
Requirement: CFMX 6.1, SQL Server 2000, Authorize.net, mail and good
customer service. Budget is 30-40$/month
http://www.extremeexperts.com/sql/faq/IIForDecode.aspx
- Original Message -
From: Richard Meredith-Hardy <[EMAIL PROTECTED]>
Date: Mon, 20 Sep 2004 10:36:13 +0100
Subject: iif in MSSQL
To: CF-Talk <[EMAIL PROTECTED]>
dear all
is there a way of doing the following in a query to MSSQL like
How about using the following udf on your string and then do a search
http://cflib.org/udf.cfm?ID=12
- Original Message -
From: Yves Arsenault <[EMAIL PROTECTED]>
Date: Fri, 17 Sep 2004 13:43:37 -0300
Subject: UDF to work with html
To: CF-Talk <[EMAIL PROTECTED]>
Hello,
I was wondering
Lori,
Even though I am not familiar with this particular package that you
are working with, here is what seem kind of confusing to me.
For all these above functions, you are passing strings, shouldn't you
be passing the actual value i.e instead of this
input.init('svgURI')>, this
Qasim
--
do you have any specific question in mind? I have developed some small
application using Java within CF.
Thanks
- Original Message -
From: Lori <[EMAIL PROTECTED]>
Date: Tue, 14 Sep 2004 23:17:14 -0400
Subject: Fw: any java cf'ers online?
To: CF-Talk <[EMAIL PROTECTED]>
Anyone out there
If you are using CFMX then Apache FOP might give you an free solution.
Here is the link
http://xml.apache.org/fop/
- Original Message -
From: Nomad <[EMAIL PROTECTED]>
Date: Mon, 13 Sep 2004 11:06:47 -0700
Subject: Cold Fusion to PDF
To: CF-Talk <[EMAIL PROTECTED]>
Hello All ,
I need so
Even though its not a CF blogging system but .Text is reallu nice with
a whole set of features
http://www.gotdotnet.com/workspaces/workspace.aspx?id=e99fccb3-1a8c-42b5-90ee-348f6b77c407
- Original Message -
From: Mark W. Breneman <[EMAIL PROTECTED]>
Date: Fri, 10 Sep 2004 11:12:22 -0500
S
s based on the "QuickBar.dat.def" and
"Toolbar.dat.def" template files.
Of course, make backups of these files, first.
M!ke
____
From: Qasim Rasheed [mailto:[EMAIL PROTECTED]
Sent: Saturday, September 04, 2004 12:37 AM
To: CF-Talk
Subject: Re: Ho
rs under the UserdData folder within the
Homesite folder?
From: Qasim Rasheed [mailto:[EMAIL PROTECTED]
Sent: Friday, September 03, 2004 5:52 PM
To: CF-Talk
Subject: Homesite Quickbar
I have somehow lost the quickbar on my HomeSite+ and now I cannot get
it back eve
I have somehow lost the quickbar on my HomeSite+ and now I cannot get
it back even if I go to view quickbar. Do someone know how can I
restore it?
Thanks
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
[Donations and Support]
Please disregard this email. I found one on www.cflib.org
On Fri, 3 Sep 2004 11:19:43 -0400, Qasim Rasheed <[EMAIL PROTECTED]> wrote:
> Hi everyone,
>
> Does somebody have a reference to any custom tag or udf written to get
> the zodiac sign from a day and month.
>
[To
Hi everyone,
Does somebody have a reference to any custom tag or udf written to get
the zodiac sign from a day and month.
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
[Donations and Support]
lect * from table
#Output Query Ran#
Christian
-Original Message-
From: Qasim Rasheed [mailto:[EMAIL PROTECTED]
Sent: Tuesday, August 31, 2004 10:37 AM
To: CF-Talk
Subject: Re: CFQuery
I guess this is what you need
http://cflib.org/udf.cfm?ID=686
- Original Message -
From: Chris
I guess this is what you need
http://cflib.org/udf.cfm?ID=686
- Original Message -
From: Christian Watt <[EMAIL PROTECTED]>
Date: Tue, 31 Aug 2004 10:21:43 -0500
Subject: CFQuery
To: CF-Talk <[EMAIL PROTECTED]>
I know you can return the execution time of a query, but how do you
return wh
Have you tried usinge structkeyexits() instead of isDefined()
- Original Message -
From: Adrian Lynch <[EMAIL PROTECTED]>
Date: Tue, 31 Aug 2004 16:22:29 +0100
Subject: Second Pair Of Eyes
To: CF-Talk <[EMAIL PROTECTED]>
Can anyone see something wrong with this, working on CFMX but failin
doesnt help when your platform wont support m$ products
-- Original Message --
From: Qasim Rasheed <[EMAIL PROTECTED]>
Reply-To: [EMAIL PROTECTED]
Date: Mon, 30 Aug 2004 15:35:54 -0400
>Have you thought about using SQL server Express instea
Have you thought about using SQL server Express instead of Access?
Qasim
- Original Message -
From: Ian Sheridan <[EMAIL PROTECTED]>
Date: Mon, 30 Aug 2004 15:26:41 -0400
Subject: Re: galleon
To: CF-Talk <[EMAIL PROTECTED]>
I would defiantly advocate for support of MySQL. Why? I develop
Joe,
Here is a link to an image manipulation application that I wrote few
weeks ago. It has a java class to do image resizing and thumbnails
using Java Advance Image API.
http://www.macromedia.com/cfusion/exchange/index.cfm#loc=en_us&view=sn106&viewName=Exchange%20Search%20Details&authorid=3363532
CFCZone has a CFC named "CF Admin Mappings" for this purpose
http://www.cfczone.org/cfcs/index.cfm
Hope it help
- Original Message -
From: Patricia Lee <[EMAIL PROTECTED]>
Date: Wed, 25 Aug 2004 16:45:36 -0400 (EDT)
Subject: Scripting to add a mapping to CF Administrator
To: CF-Talk <[EM
Thanks Charlie that worked perfectly
- Original Message -
From: Charlie Griefer <[EMAIL PROTECTED]>
Date: Wed, 25 Aug 2004 13:14:14 -0700
Subject: Re: A Quick Question - _javascript_
To: CF-Talk <[EMAIL PROTECTED]>
"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
Untitled
Hello everyone,
Using _javascript_, I want to display numbers from 1 to 5 such that
numbers are ordered randomly on each page refresh and none of the
number is repeated.
e.g
first refresh 1,3,4,2,5
second refesh 2,3,5,1,2
etc etc
Any help is appreciated.
Thanks
[Todays Threads]
[This Messa
Nando, You you by any chance have link to that live doc?
Thanks
- Original Message -
From: Nando <[EMAIL PROTECTED]>
Date: Wed, 25 Aug 2004 03:37:41 +0200
Subject: Re: Query of Queries functionality in Java?
To: CF-Talk <[EMAIL PROTECTED]>
Yeah, the datatype thing is a drag. That one rea
This might help you
http://clearsoftware.net/client/queryTool.cfm
On Mon, 23 Aug 2004 17:20:13 -0500, Paul Giesenhagen
<[EMAIL PROTECTED]> wrote:
> I have some Queries that I want to convert a record to either an Array or a Struct (different queries, different requirements).
>
> What is the easi
As far as I know most drop down menu will not show up if over a select
box. Select boxes are essentially created by the OS rather than the
browser, and therefore do not respond well to layering... they always
want to be on top. The only solution is to put the select element
inside of a div then hi
If you type "http://" in the search box on google homepage and press I
am feeling lucky, you are directed to Microsoft homepage. Any reasons?
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
[Donations and Support]
I have to install ColdFusion 5.0 recently and now IIS is showing the
file download box if I try ti run any coldfusion page. Any thoughts?
Thanks
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
[Donations and Support]
Does anyone have recommendation for software that can be used for
project/time tracking. Nothing fancy, just basic time entry and
reports/invoices. Ease of use and preferrably a stand alone
application. Free or inexpensive. It will only be used by one person.
Thanks
[Todays Threads]
[This Messa
Micha,
Unfortunately I am using Access, so stored procedures are not an
option, however thanks for sending me an excellent code which I would
keep for future reference.
- Original Message -
From: Micha Schopman <[EMAIL PROTECTED]>
Date: Thu, 19 Aug 2004 12:53:49 +0200
Subject: RE: Access
Pass the message with cflocation too
variables.msg )#">
- Original Message -
From: Mark Henderson <[EMAIL PROTECTED]>
Date: Thu, 19 Aug 2004 12:43:32 +1200
Subject: form validation problems
To: CF-Talk <[EMAIL PROTECTED]>
I've recently revisited some form validation issues,
DELETE
FROM myTable
WHEREparent = 3
Or do you want to be able to recursively delete descendents (i.e. children,
cgrandchildren.) at all levels?
_____
From: Qasim Rasheed [mailto:[EMAIL PROTECTED]
Sent: Thursday, 19 August 2004 8:32 a.m.
To: CF-Talk
Subject: Access SQL Question
Is
Is there a way in access where you can delete all the child of a
parent e.g. if I am deleting a record which a children and
children(s) may or may not have child. Here is db schema
id,name,parent
1,test1,0
2,test2,0
3,test3,1
4,test4,3
any help is appreciated
[Todays Threads]
[This Message]
This is from the documentation
attributes: selected(Optional) - A list of option values to preselect
in the selection list. This attribute applies only if list items are
generated from a query. The cfform preservedata attribute value can
override this value.
- Original Message -
From: CF
shouldn't you be using an update instead of insert?
- Original Message -
From: Scott Stewart <[EMAIL PROTECTED]>
Date: Tue, 17 Aug 2004 15:49:19 -0400
Subject: RE: Inserting a query string into a text field
To: CF-Talk <[EMAIL PROTECTED]>
Here's the CF Code
INSERT INTO tbl_CampaignMgrAc
ubject: Re: SQL Question
To: CF-Talk <[EMAIL PROTECTED]>
So you don't know the table names, the primary keys, or ANY of the
column names in these tables?
- Original Message -----
From: Qasim Rasheed
To: CF-Talk
Sent: Monday, August 16, 2004 3:07 PM
Subject: Re: SQL
nto the table from temp.
>
> On Mon, 16 Aug 2004 15:19:39 -0400, Qasim Rasheed
> <[EMAIL PROTECTED]> wrote:
> > Hello
> >
> > I want to delete all records from a table except one (a random one).
> > Is there a way to do it? I am using SQL Server
> &g
mp table and save a record to it
and then delete out the entire original table and then insert the
single row back into the table from temp.
On Mon, 16 Aug 2004 15:19:39 -0400, Qasim Rasheed
<[EMAIL PROTECTED]> wrote:
> Hello
>
> I want to delete all records from a tabl
think you'd probably have to have a temp table and save a record to it
and then delete out the entire original table and then insert the
single row back into the table from temp.
On Mon, 16 Aug 2004 15:19:39 -0400, Qasim Rasheed
<[EMAIL PROTECTED]> wrote:
> Hello
>
> I want to
Hello
I want to delete all records from a table except one (a random one).
Is there a way to do it? I am using SQL Server
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
[Donations and Support]
http://uptime.netcraft.com/up/graph/?host=www.athens2004.com
- Original Message -
From: Michael Kear <[EMAIL PROTECTED]>
Date: Sun, 15 Aug 2004 12:03:31 +1000
Subject: Olympics web site - anyone know anything about how it's built?
To: CF-Talk <[EMAIL PROTECTED]>
Now that the Olympics are
Just out of curiosity, how have you managed to read MSysobjects? When
I tried it on my local machine I got the following error
[Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC
Microsoft Access Driver] Record(s) cannot be read; no read permission
on 'MsysObjects'
Any thoughts?
---
Shouldn't you be doing something like this
stReturn.a= ListGetAt( Valuelist( qGetSiteConfig.Config_VariableName
), ListFindNoCase( valuelist( qGetSiteConfig.Config_Name ),
"RequirementsTitle"))
- Original Message -
From: Carl V <[EMAIL PROTECTED]>
Date: Sun, 08 Aug 2004 15:53:46 -0400
S
Here is an example
method="GET" getasbinary="yes">
file="#getdirectoryfrompath(getcurrenttemplatepath())#\temp.jpg"
output="#cfhttp.filecontent#">
- Original Message -
From: John Croney <[EMAIL PROTECTED]>
Date: Fri, 06 Aug 2004 21:50:57 -0400
Subject: Re: Downloading image
To: CF-Talk
You can use cfhttp for this purpose and use cfhttp.filecontent to save
the image on your server utilizing cffile.
On Fri, 06 Aug 2004 16:26:06 -0400, John Croney <[EMAIL PROTECTED]> wrote:
> How can I download this image : http://www.nrlmry.navy.mil/htdocs_dyn/thumbnails/sat_thumbs/atlantic/tropic
If you are using CFMX, then why not just use Java Advance Image API (JAI)?
- Original Message -
From: dave <[EMAIL PROTECTED]>
Date: Fri, 6 Aug 2004 00:24:06 -0400
Subject: linux image manip tags
To: CF-Talk <[EMAIL PROTECTED]>
what are the options (free or otherwise) for a simple image
Ray,
I recently sent an email to the list with the application attached as
a zip file. Let me know if there is any problem
Thanks
Qasim
- Original Message -
From: Ray Champagne <[EMAIL PROTECTED]>
Date: Wed, 04 Aug 2004 15:46:52 -0400
Subject: Re: Image Manipulation - server side
To: CF
yes I am pretty sure about it. The Arabic text in my SQL Server is
display correctly whose datatype is ntext but somehow when the records
are returned from database for CF5 its all ??. Any thoughts?
Qasim
- Original Message -
From: Paul Hastings <[EMAIL PROTECTED]>
Date: Wed, 4 Aug 2004 0
Aaron,
How are you handling insertion of data into database with Arabic text
on CF5. I mean which dbms, odbc driver etc?
Thanks
Qasim
- Original Message -
From: Aaron Rouse <[EMAIL PROTECTED]>
Date: Wed, 4 Aug 2004 10:43:13 -0500
Subject: Re: Arabic Text
To: CF-Talk <[EMAIL PROTECTED]>
ge the charset to utf-8.
CFMX uses utf-8 natively and i've seen it completely ignore meta
http-equiv="Content-Type" tags that worked fine in CF5. Just a guess.
-Original Message-
From: Qasim Rasheed [mailto:[EMAIL PROTECTED]
Sent: Tuesday, August 03, 2004 6:53 PM
To: CF-
Hello everyone,
I have a webpage with an Arabic Keyboard which is displayed using some
_javascript_ to display various buttons. It works fine on CFMX but just
display ?? on CF 5 running on the same machine and using the same
browser. I have following set on my display page
Any thoughts? Thanks
Paul,
Thanks for a quick response. Do you by any chance know the meta-header
for setting the content type?
Qasim
- Original Message -
From: Paul Hastings <[EMAIL PROTECTED]>
Date: Tue, 3 Aug 2004 14:03:04 +0700
Subject: Re: CF5 Encoding
To: CF-Talk <[EMAIL PROTECTED]>
> Can someone poin
Douglas,
There is something wrong with my cable connection. Yes I am using JAI
for image manipulation and this application is built using mach-ii.
Qasim
- Original Message -
From: [EMAIL PROTECTED] <[EMAIL PROTECTED]>
Date: Tue, 03 Aug 2004 13:31:07 +
Subject: Re: Image Manipulation
201 - 300 of 358 matches
Mail list logo