I struggled with the CFS/HomeSite+ debugging for quite a while trying to get it to be something I could effectively use. I finally decided it was easier and more productive to use cfabort.
Which is a shame, an interactive debugger that actually works in DWMX would really help bring that tool and
Yeah, i'm validating against an XSD.In a nutshell I am looking for some
code that will allow me to pass in an XML string, a XSD string (or path) and
get a result back.
I've been googling this morning for something that might help but come up
with very little.I really can't beleive someone
Thanks a lot Craig for your timely help. I'm using the code you posted, this was exactly what I was after, thanks again. Also thank you Peter for your help
Best Regards
Allan
This works,
it's a bit of a fudge, but it does the job.
cfset qTmp = QueryNew(DateTime,User,Document,Status)
cfloop
Try to look at Xalan and Xerces samples, starting from:
http://xml.apache.org/xalan-j/samples.html#validate
You can use Java directely or integrate it in CFML like I did for validating
against a DTD
Massimo Foti
Certified Dreamweaver MX Developer
Certified Advanced
I was wondering if the SQL gurus out there could help.
I have this table that keps a log
of the user search activity. For ex, on the site
search page of the site, if a user searches for
a keyword test, it gets stored on the database table
along with other details like the
username, date/time,
Allan Clarke wrote:
I have this table that keps a log
of the user search activity. For ex, on the site
search page of the site, if a user searches for
a keyword test, it gets stored on the database table
along with other details like the
username, date/time, search category and the results
Hi Jochem, Can you explain what the where statement in your code does, I don't understand the the EXTRACT(DAYS FROM CURRENT_TIMESTAMP - DateTime) 7 bit
Many Thanks
Allan Clarke wrote:
I have this table that keps a log
of the user search activity. For ex, on the site
search page of the site,
AMEN to that! (debugger in DWMX)
I was really hoping that 2004 version would finally include what we lost in CFStudio... alas, i'm disappointed again :(
Anyone know why it isn't in there? Is there not enough demand or is it just too hard to implement?
Mitch
Shameless plug for my wife's
ColdFusion Programmer wrote:
Hi Jochem, Can you explain what the where statement in your code
does, I don't understand the the EXTRACT(DAYS FROM
CURRENT_TIMESTAMP - DateTime) 7 bit
Read it inside out:
CURRENT_TIMESTAMP - the current date and time, 'now'
DateTime- your field with the moment
I used enterprise manager to use TCP/IP, named pipes, and multi protocol. I couldn't connect on anything but (local) before I did that.
Bob Everland
I just checked with the OSQL utility and I can log into it
with the sa username and password. So I know that works now,
I also used the update
I am using Enterprise Manager and I have verified that I do have sql authorization by using the command prompt tool osql and loggin on as sa.
Bob Everland
out of the box, msde installs with trusted only authentication. there's an
install switch but its buried deep 99.99% of installs go w/the
This is what I'm doing, and I get an error. I'm using SQL Server 2000
cfquery name=lQuery2 dbtype=query
SELECT UserName, SearchString, Count(SearchString) AS Occurences
FROM
WHERE (#DateFormat(Now(),/mm/dd)# #TimeFormat(Now(),HH:mm:ss)# - #qTmp.DateTime#) 7
qTmp
GROUP BY UserName,
from wheredoesn't jive.
cfquery name=lQuery2 dbtype=query
SELECT UserName, SearchString, Count(SearchString) AS Occurences
FROM yourTableName
WHERE (#DateFormat(Now(),/mm/dd)#
#TimeFormat(Now(),HH:mm:ss)# - #qTmp.DateTime#) 7 qTmp
GROUP BY UserName, SearchString
/cfquery
replace,
Sorry this is the query I'm using
cfquery name=lQuery2 dbtype=query
SELECT UserName, SearchString, Count(SearchString) AS Occurences
FROM qTmp
WHERE (#Now()# - DateTime) 7
GROUP BY UserName, SearchString
/cfquery
This is what I'm doing, and I get an error. I'm using SQL Server 2000
cfquery
now() isnt a sql function, getDate() is tho' :)
...tony
tony weeg
senior web applications architect
navtrak, inc.
www.navtrak.net
[EMAIL PROTECTED]
410.548.2337
-Original Message-
From: ColdFusion Programmer [mailto:[EMAIL PROTECTED]
Sent: Friday, October 10, 2003 8:35 AM
To: CF-Talk
and besides that, what are the values that you are expecting
to do a subtraction operation with?
to me, I don't see how,(#Now()# - DateTime) would make sense regardless.
are you trying to see if the number of days between getDate() (or now() as
you have it)
are greater than seven?sql server has
Tony Weeg wrote:
now() isnt a sql function, getDate() is tho' :)
Neither are SQL functions (copies of ISO 9075-2:1999 are available
through your national standards organisation).
Jochem
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
getDate isnt?
...tony
tony weeg
senior web applications architect
navtrak, inc.
www.navtrak.net
[EMAIL PROTECTED]
410.548.2337
-Original Message-
From: Jochem van Dieten [mailto:[EMAIL PROTECTED]
Sent: Friday, October 10, 2003 8:39 AM
To: CF-Talk
Subject: RE: SQL Statement help!
Tony
I guess standards matter in some cases, but, jochem, this is fairly clear in
its descriptive text of a function available to sql server programmers.
--from transact sql help docs-
GETDATE
Returns the current system date and time in the MicrosoftR SQL ServerT
standard
ColdFusion Programmer wrote:
This is what I'm doing, and I get an error. I'm using SQL Server
2000
No, you are not. Since your dbtype is query, you are using CF.
cfquery name=lQuery2 dbtype=query
SELECT UserName, SearchString, Count(SearchString) AS Occurences
FROM
WHERE
Tony Weeg wrote:
and besides that, what are the values that you are expecting
to do a subtraction operation with?
to me, I don't see how,(#Now()# - DateTime) would make sense
regardless.
In full featured databases, they return an interval. Unfortunately,
neither Java nor JDBC has an interval
Tony Weeg wrote:
I guess standards matter in some cases, but, jochem, this is fairly
clear in its descriptive text of a function available to sql server
programmers.
--from transact sql help docs-
Transact SQL SQL
Why do you think I explicitly refered Allan to
Guys, I'm sorry for so many errors on my part. Jochem, the code your posted throws an error,
Error Executing Database Query.
Query Of Queries syntax error.
Encountered { at line 0, column 0. Incorrect conditional _expression_, Expected one of [like|null|between|in|comparison] condition,
Any
your 100% right.
but his arena is sql server.so in his world, transactsql == sql, at least
for today, and at least for this answer he is looking for.
whatever, have a good morning...i don't have the mental time to devote to
this argument :)
later.
...tony
tony weeg
senior web applications
I have tried using the undocumented cfset CFUSION_DBCONNECTIONS_FLUSH()but it is not flushing query results and forcing a new query (I want to flush the cached queryies whenever an administrator updates info in the database).Is there any other way to flush cached query results?I am using CF5 on
its because of the odbc datetime format that that will give you...the
getDate function that is...and the qOfq prolly doesn't like that?try,
adding a dateFormat() around that, so that its in a format the qOfq will
jive with.
SELECTUserName,
SearchString,
Count(SearchString) AS Occurences
FROMqTmp
ColdFusion Programmer wrote:
Guys, I'm sorry for so many errors on my part. Jochem, the code your
posted throws an error,
Error Executing Database Query.
Query Of Queries syntax error.
Encountered { at line 0, column 0. Incorrect conditional
_expression_, Expected one of
I thought that DBCOMMECTIONS_FLUSH only flushed the ODBC connectors, not
the cached queries
Anyways, the way I do it is to put a CreateTimeSpan(0,0,0,0) in the
CACHEDWITHIN, that tells CF to get the latest data
If you're using CACHEDWITHIN, then I'd suggest putting the time span
into a
cfobjectcache action="">
Good luck,
-JSLucido
-Original Message-
From: Pete Ruckelshaus [mailto:[EMAIL PROTECTED]
Sent: Friday, October 10, 2003 8:03 AM
To: CF-Talk
Subject: How do I flush cached queries?
I have tried using the undocumented cfset
CFUSION_DBCONNECTIONS_FLUSH()but it
Oops, I am pretty sure this works in CF5 but I can't remember if I used
it back then or not. This definitely works in MX. Also, the
cachewithin attribute is pretty much a must unless you have a query
you want to keep indefinitely (be nice to your RAM memory, it is your
friend). Another point, this
I now get a different error
Query Of Queries runtime error.
Unsupported type comparison.
ColdFusion Programmer wrote:
Guys, I'm sorry for so many errors on my part. Jochem, the code your
posted throws an error,
Error Executing Database Query.
Query Of Queries syntax error.
Encountered {
whats the value of dateTime parse out to?
...tony
tony weeg
senior web applications architect
navtrak, inc.
www.navtrak.net
[EMAIL PROTECTED]
410.548.2337
-Original Message-
From: ColdFusion Programmer [mailto:[EMAIL PROTECTED]
Sent: Friday, October 10, 2003 9:32 AM
To: CF-Talk
http://webforums.macromedia.com/coldfusion/messageview.cfm?catid=6 http://webforums.macromedia.com/coldfusion/messageview.cfm?catid=6threadid=684306highlight_key=ykeyword1=No%20more%20data%20available%20to%20read threadid=684306highlight_key=ykeyword1=No%20more%20data%20available%20to%20read
Hi,
I'm writing a content management system and am trying to determine the best way to start the process of retrieving content.We're using human readable urls, and have a url lookup in the database.So when a user goes to a url such as www.edu/science/astronomy.cfm the page doesn't really
I have the following query, however if I enter more than one value in the search form such as
Surname = Vaughan
Funding = budget
CFQUERY datasource=liv8 name=funding
SELECT * FROM funding
WHERE 1=1
cfif Len(Trim(form.orgname))
AND UPPER(orgname) LIKE UPPER(cfqueryparam cfsqltype=CF_SQL_VARCHAR
You can also try the FlashFusion list at
http://www.flashcfm.com
-Kevin
- Original Message -
From: Kola Oyedeji [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Thursday, October 09, 2003 7:05 AM
Subject: RE: CF + Flash list
Apparently
The fig leaf lists are quite good
Iam having some trouble with cfif statements
If I enter more than one value in the search form such as
Surname = Vaughan
Funding = budget
The results bring back all surname records where the funding = budget when it should be bringing back only the surnames that contain Vaughan
Is it
Hello All,
I am run into some issues using SES with a fusebox app that I have on windows 2003 on a shared hosting environment.I keep getting errors with IIS trying to locate the dummy file at the end of my url.
My question is has anyone run into this problem?And is SES needed anymore with the
You need seperate CFIFs around each one, the elseifs stop when it hits one that evaluates to true (in this case, budget)
Eric
-Original Message-
From: Ian Vaughan [mailto:[EMAIL PROTECTED]
Sent: Friday, October 10, 2003 9:59 AM
To: CF-Talk
Subject: CFIF Troubles!!!
Iam having some
Ian,
The problem is with the way you are using cfif and cfelseif.
Each of the cfelseifs should be their own cfifs.When the formfunding is
processed, the processing of the cfif stops.
Here is the modified code:
CFQUERY datasource=liv8 name=funding
SELECT * FROM funding
WHERE 1=1
cfif
Ian,
On 10/10/2003 at 09:59, you wrote:
IV Is it something to do with my CFIF statements?
IV CFQUERY datasource=liv8 name=funding
IV SELECT * FROM funding
IV WHERE 1=1
IV cfif Len(Trim(form.orgname))AND UPPER(orgname) LIKE
IV UPPER(cfqueryparam cfsqltype=CF_SQL_VARCHAR
IV
Thanks folks,
It is now working is at should
- Original Message -
From: DURETTE, STEVEN J (AIT)
To: CF-Talk
Sent: Friday, October 10, 2003 3:08 PM
Subject: RE: CFIF Troubles!!!
Ian,
The problem is with the way you are using cfif and cfelseif.
Each of the cfelseifs should be
Changing it to nobody as Christine requested resolved this error. Can anyone tell me the exact permissions/group my runtime_user needs? We don't wan't to use nobody in production. Any tips are appreciated!
Thank you,
Lee
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
hi all
I have a problem with openning a connection to a
data source for DreamweaverMX. It fail connection.
Can someone help me out
__
Do you Yahoo!?
The New Yahoo! Shopping - with improved product search
http://shopping.yahoo.com
[Todays Threads]
[This
I think this is what you mean
DateTime - 2003/09/01 11:52:16
Now - {ts '2003-10-10 15:28:19'}
whats the value of dateTime parse out to?
...tony
tony weeg
senior web applications architect
navtrak, inc.
www.navtrak.net
[EMAIL PROTECTED]
410.548.2337
-Original Message-
From: ColdFusion
The problem is with caching dynamic queries.If you cache a query that has dynamic statements, it will cache the result set from each dynamic statement that is run.
I'll try Jeff's solution.
Thanks for the help!
Pete
- Original Message -
From: Philip Arnold
To: CF-Talk
Sent: Friday,
Hey All,
When attempting to upgrade from CFMX 6.0 to CFMX 6.1 on we get an error:
ANT Script Error:
Status: ERROR
Additional Notes: ERROR - 26: Java returned:
1
Has anyone else experienced this error?
We run:
Solaris 8 - OS
Apache 1.3 - Web Server
on a Sun SPARC Server.
Thanks,
Hey everyone.
I've currently been asked by my boss to do a large application in Zope.
(www.zope.org)
We always done Coldfusion but despite the fact that he is not technical,
he's certain that the project we are doing could be built faster in
Zope.Despite that I've already made a case that Zope
Hi
This is my code..
cfloop index=listitem list=#form.fieldnames#
cfif (lcase(left(listitem,4)) is sql_) or
(lcase(left(listitem,7)) is hidden_)
cfif fields neq
cfset fields = #fields#,
/cfif
!--- replace single quotes with double quotes for
SQL ---
cfset temp =
Thanks Jeff,
I'm not certain (off the top of my head) if query caching was really
included in the onTap framework. The method I usually use is to create
a structure to hold dates for caching in the application scope. Any
time a given query is run, it uses cfparam to ensure a date value for
that
Python is a fantastic language - it's up there with ColdFusion for
general ease-of-coding in my opinion.If you'd like a very concise and
well-written introduction, this book, Learning Python by O'Reilly
(http://www.oreilly.com/catalog/lpython/) is great.
One great thing about Python is the
have a shopping cart that it is losing all of its values when the user hits the checkout button and takes them to my secure checkout page. Example, the user is shopping at www.mystore.com and purchase several items which are saved as session variables (session.mysession), they then would click on
When I run the code I get the following error:
Server: Msg 18456, Level 14, State 1, Line 1
Login failed for user 'us/orl1jdt'.
[OLE/DB provider returned message: Invalid connection string attribute]
select *
from OPENROWSET('SQLoledb','UID=domain/uid;PWD=pass;
This sounds fantastic!
Would you be able to write Java applications in Jython (I am assuming
that Python is a lot easier to write than Java code) to run on Cell
Phones?
:-)
Where can I get Jython?
err...I guess I could Google it...
-Gel
-Original Message-
From: Jim Campbell
When I run the code I get the following error:
Server: Msg 18456, Level 14, State 1, Line 1
Login failed for user 'us/orl1jdt'.
[OLE/DB provider returned message: Invalid connection string
attribute]
select *
from OPENROWSET('SQLoledb','UID=domain/uid;PWD=pass;
All--
I'm stuck with CFStudio 4.5.2 and need the tag updates for CFMX 6.1.I tried the download from MACR but it doesn't appear to be correct.For ex, there's no CFFUNCTION in the tags.Does anyone have a link they could share?
Thanks,
Chris
[Todays Threads]
[This Message]
[Subscription]
If anyone is in Boston on Wednesday, Dec 13, the CEO of Zope Corporation will be presenting an overview of Zope at the Boston Linux and Unix Group at MIT.
http://www.blu.org/cgi-bin/calendar/2003-dec http://www.blu.org/cgi-bin/calendar/2003-dec
-Original Message-
From: Glen Salisbury
Lari:
I have had the same problem in the past. One thing I did was when I was
ready to move to the SSL side of the site I had my form post to a CF
page where I check values, etc. and then do a CFLOCATION to the secure
address while using the attribute addtoken set to yes.
Another way I got
I know that, I am running that code in a stored procedure.What I want to know is how do I put correct information in the code to accept a domain id and pass.
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
You can loop over the form structure instead and avoid the fieldnames var OR you can keep the treated fields in a list
cfset treatedFields =
cfloop index=listitem list=#form.fieldnames#
cfif NOT ListFind(treatedFields,listitem)
cfset treatedFields = ListAppend(treatedFields,listitem)
!--- rest
Does anyone have experience with CFMX 6.1 (particularly J2EE, on Win2K Adv
Server) using the JDBC Type4 drivers for DB2 supplied by Macromedia (Merant
- DataDirect?) and/or the ones supplied by IBM to access DB2 on OS/390?
We have the Merant/DataDirect drivers working but we haven't tried the IBM
ok so format that value, with dateFormat, enclose it in 's and you should be
good.
...tony
tony weeg
senior web applications architect
navtrak, inc.
www.navtrak.net
[EMAIL PROTECTED]
410.548.2337
-Original Message-
From: ColdFusion Programmer [mailto:[EMAIL PROTECTED]
Sent: Friday,
Why not include a db field in your cms' page record that is
'FriendlyPageName'. You could then eliminate your need to perform
lookups entirely.
This could also -- depending on your app needs -- allow you to publish
physically discrete, fully or partially static pages where the page name
you
the syntax and pecadilloes of Python (tabbing and whitespace are VERY
important) it's fairly straightforward.
...and you say that with a straight face.
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
I assume you could - Whatever you write in Jython is going to be usable
Java bytecode, so implementing J2ME should be quite possible.However,
you might be limited in what tools you can use, since Jython is a J2SE
application, and J2ME doesn't have quite the range of capabilities of
J2SE (I
:) On the internet, no one can see you laughing.That, and pretty much
any Python IDE will keep your code nice and clean.I've made the
mistake of writing Python in Notepad and had way too many problems with
just that.
- Jim
Paul Hastings wrote:
the syntax and pecadilloes of Python (tabbing
What is the best way to duplicate an entire SQL server from one instance to another?I'd like to pull our production db's from our live sql server to a new dev instance.I'd rather not kill the sql service to unlick the files.
Off the top of my head, I could:
1.dts db by db
2.copy mdfs/ldfs and
Hi All,
I made all the suggested changes to my code and now it
works properly! Thanks everyone!
Laura
--- [EMAIL PROTECTED],
[EMAIL PROTECTED] wrote:
As Ben has noted, the hidden field should have pound
signs to be recognized, but this leads to the
following, real, issue:
Your form tag is
We always done Coldfusion but despite the fact that he is not
technical, he's certain that the project we are doing could be
built faster in Zope. Despite that I've already made a case
that Zope market is tiny, (try doing a job search on it) and
that none of the dev team knows Python
I built a CMS that did this.
All the dynamic content had a static page , this page consisted of metatags,
page title etc. and the page id then a call to a CFC to get the content from
the DB.
Hey presto, static pages for those people that dont like strange urls and it
also has the benefit of
I know that, I am running that code in a stored procedure.
What I want to know is how do I put correct information in
the code to accept a domain id and pass.
I don't think you can put that information in your code. That's not how
Windows authentication generally works.
Dave Watts, CTO, Fig
Whitespace in the code is important?
In this day and age that seems pretty backward :-)
-Gel
-Original Message-
From: Jim Campbell [mailto:[EMAIL PROTECTED]
:) On the internet, no one can see you laughing.That, and pretty much
any Python IDE will keep your code nice and
On Friday 10 Oct 2003 14:51 pm, Zimba, Janice C. wrote:
1) Use a url such as www.edu/index.cfm/science/astronomy instead, where
index.cfm will start the ball rolling and run the processes needed.
You can do this, but without the .cfm in the URL, if you like. There was a
recent posting about it
Whitespace in the code is important?
In this day and age that seems pretty backward :-)
Why does it seem backward? In older programming languages, whitespace isn't
important, and you need metacharacters to tell you when lines end, or to
show you where code blocks begin and end. In real
Whitespace in the code is important?
In this day and age that seems pretty backward :-)
The whitespace has to do with horizontal whitespace (tabs) predominantly.
When coding and if statement, for example, there's no concept of curly
braces to surround your code block with. You tab-indent for
Whitespace in Python's been a contentious issue from the get-go.
Essentially, whitespace is used instead of punctuation to specify a
block of code (I lifted this example from Wikipedia):
def factorial(x):
if x == 0:
return 1
else:
return x * factorial(x-1)
While in C, it would be (again, from
show you where code blocks begin and end. In real languages, like
English,
we often use whitespace to provide information.
well english is kind of like, well olde and usually no human being stops
working if we misplace a space or two. i used to work in a macro language
(AML used to control
I've tried this and it errors:
cfoutput#DateFormat(Now()-7,/mm/dd)# - #qTmp.DateTime#/cfoutput
cfquery name=lQuery2 dbtype=query
SELECTUserName, SearchString, Count(SearchString) AS Occurences
FROMqTmp
WHERE cfqueryparam cfsqltype=cf_sql_timestamp value=#DateFormat(Now()-7,'/mm/dd')#
Always use Vendor Specific JDBC Drivers, they always support the database well and are more reliable
with Service Packs for the DB.
Why dont you use IBM DB2 JDBC Type IV Drivers for OS/390 Rather than DB2 Connect.
Last time i checked DB2 Connect was a PAIN, Not Easy to SetUp and relied heavily
In this day and age that seems pretty backward
How about Fortran then? ;-)
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
first of all, whats this?
cfoutput#DateFormat(Now()-7,/mm/dd)# - #qTmp.DateTime#/cfoutput
dateAdd() needs to be in there for the -7 thing to work.
here is the below in correct format.
cfquery name=lQuery2 dbtype=query
SELECTUserName, SearchString, Count(SearchString) AS Occurences
FROMqTmp
Basically the same thing, and I find it to be a little easier to read
without all those brackets,
It depends how you use brackets. Personally I use them as blank lines, a little like it would look in Python,
and mostly: no braket when it is not necessary.
Your piece of code would ;ook like:
int
Not only is he non technical, but also non logical.Even if it's true that you can build applications faster in Zope, you still have to factor in the time it will take you/your team to learn it and get to know the ins and outs of it.
- Original Message -
From: Glen Salisbury
To: CF-Talk
ColdFusion Programmer wrote:
cfoutput#DateFormat(Now()-7,/mm/dd)# - #qTmp.DateTime#/cfoutput
cfquery name=lQuery2 dbtype=query
SELECTUserName, SearchString, Count(SearchString) AS Occurences
FROMqTmp
WHERE cfqueryparam cfsqltype=cf_sql_timestamp value=#DateFormat(Now()-7,'/mm/dd')#
In older programming languages, whitespace isn't important,
Depends how old you're thinking.
Back in 60's and 70's, THE language was FORTRAN, on punched cards;
Columns 1 to 5 were for a statement label (number), column 6 was for a continuation mark,
columns 7 to 71 were for a statement, and
I'm looking for alternative Forums that are codedin Cold Fusion like FuseTalk but not as expensive.
If anyone knows that would be great.
Thanks
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
Zimba, Janice C. wrote:
So when a user goes to a url such as www.edu/science/astronomy.cfm the page doesn't really exist.The process will look up the correct document and retrieve the correct content.
4. Use a servlet:
If you have skills in a programming language, your next project written in
said language is bound to have better programming than all your earlier
projects. If you have no skills in a particular language, your first project
is bound to be full of holes and other serious problems.
IMHO, I would
I wasn't even a gleam in my parents eye at that point in time. ;-)
Stace
_
From: Claude Schneegans [mailto:[EMAIL PROTECTED]
Sent: October 10, 2003 12:19 PM
To: CF-Talk
Subject: Re: Coldfusion VS Zope (Python) ... HELP!!
In older programming languages, whitespace isn't important,
Depends
Hi all
Hope someone can help me with this:
How can I tell a SP to query a different dbs inside of a SP?
I need to be able to run some queries on one db and within that same SP run
queries on another db.
IS this possible?Or will I need to do two different SP one in each db and
a temp table to
The open cursors error can be fixed by the cursors setting in the Oracle DB itself. Not sure how to do it myself, I just ask our DBA's.
:-)
Chris Norloff
-- Original Message --
From: [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
Date:Tue, 7 Oct 2003
Hi all
Hope someone can help me with this:
How can I tell a SP to query a different dbs inside of a SP?
I need to be able to run some queries on one db and within that same SP run
queries on another db.
IS this possible?Or will I need to do two different SP one in each db and
a temp table to
I'm trying to write an _expression_ that will remove any SHTML include tags. I
am getting a bad regular _expression_ error from cf5. What is wrong?
Thanks,
Jon
_expression_:
CFSET VARIABLES.blingBling = reReplaceNoCase(VARIABLES.X,
!--.*##include.*--, , ALL)
[Todays Threads]
[This Message]
Isn't it .., as in
SELECT tb1.id, tb2.name
FROM db1..table1 tb1, db2..table2 tb2
?
-Original Message-
From: Dave Carabetta [mailto:[EMAIL PROTECTED]
Sent: Friday, October 10, 2003 12:22 PM
To: CF-Talk
Subject: Re: SQL SP
Hi all
Hope someone can help me with this:
How can I tell a
Is there a flash grid that acts in many ways like the CFGRID tag and is easy to impliment. I'm looking for something that I can slap onto a page like this:
swf call
line data1
line data2
line data3
etc.
If it can be (or has been) wrapped into a custom tag then cool. The mail thing needed is the
You mean like the old, free Allaire forums found here:
http://houseoffusion.com/forumspot/
I'm looking for alternative Forums that are codedin Cold Fusion like
FuseTalk but not as expensive.
If anyone knows that would be great.
Thanks
[Todays Threads]
[This Message]
[Subscription]
[Fast
Flash MX 2004 Pro has a Datagrid component. That is essentially what
CFGRID is but it might be more stable than CFGRID.
Ben
-Original Message-
From: Michael Dinowitz [mailto:[EMAIL PROTECTED]
Sent: Friday, October 10, 2003 1:43 PM
To: CF-Talk
Subject: CF Flash grid
Is there a flash
If it helps any, I've just started implementing Zope on my personal server,
but code in CF professionally.My experience thus far is that Zope does
have a lot of potential to make life easy.I've installed Plone on top of
Zope, then within an hour, I had a basic web site up and running, with
editing
For that matter, Flash MX has a datagrid and by default all the columns
are sortable.
http://www.digital12studios.com/contact/
HTH,
Clint
Ben Densmore wrote:
Flash MX 2004 Pro has a Datagrid component. That is essentially what
CFGRID is but it might be more stable than CFGRID.
Ben
Try escaping your dashes, the RegEx engine sometimes gets confused, like I
know [a-z-A-Z] will freak it out, you have to put those dashes at the end.
In fact, for a test, take the dashes out completely to see if that may be
the problem, then try different ways of putting them back in, like [-]{2}
1 - 100 of 193 matches
Mail list logo
