> What I'm wondering, though, is if there is a way for me to run a query in
my
> application.cfm to determine the version of the database I'm running. At
> the moment I'm exploring using a CFCatch around a specific MySQL query
> (select version()), but does anyone have any better ideas of how to g
Clint
> > The only 2 tools you need Flash MX 2004 Professional and Sapien's
> > PrimalScript www.sapien.com.
>
> > > What's the minimum software requirement for developing Flash
> > > apps? What would be the benefits of alternatives to the minimum?
Why is PrimalScript part of the minimum require
> And if the user does not have cookies turned on? No session scope avail
> then :-(
Not exactly
http://livedocs.macromedia.com/coldfusion/6/Developing_ColdFusion_MX_Applica
tions_with_CFML/sharedVars3.htm
Nick
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Set
Mark
> Update MyTable
> SET email =
Len(FORM.email)>'#FORM.email#'NULL
> Where memberID = #FORM.memberID#
Looks good to me. Unless you want to use -
http://www.macromedia.com/devnet/mx/coldfusion/articles/cfqueryparam.html
Nick
[Todays Threads]
[This Message]
[Subscriptio
Mark
> All the empty fields in the email db contain
How exactly do you know the email field is null? It seems to me that if
"WHERE L.email IS NOT NULL" returns the rows, then that's the surest proof
that the field is not null.
Nick
[Todays Threads]
[This Message]
[Subscription]
[Fast Uns
Jochem
> unfortunately CFML doesn't allow the clean syntax PHP and C allow
cfscript?
Nick
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
Matt
> I have a field name in a db that I'd like to rename from fieldname1 to
> fieldname2 (leaving the data intact and fieldspecs the same) via a SQL
> statement.
MySQL is unusually obliging in this respect. IIRC in SQL Server you need to
use sp_rename() to rename a column.
I'm not at all sure
Mark
> In the following query I want the email addresses from two different
tables
> to be grouped together (for sending in CFMail), can't get it to work, what
> am I missing? (BTW: the individual queries work just not as a UNION)
Try putting the column names in the same order in both parts of th
Scott
> Other than stripping out the degree symbols in the data first (which is
> a bit of a kluge and leads to a time when I see us having to strip out
> other characters), is there something else we can try?
Also a kludge I guess but you could substitute them all with the entity
°
Nick
[Today
Mickael
> Hi I don't really have that skill set, is that the only way to do this?
In Access, I think so. Most other DBMS have tables that you can query for
this info but Access only has a table of tables, not a table of columns.
The ADO way is not too hard using CFOBJECT iirc.
Nick
[Todays Thr
Novak
> It's really nothing more than a Flash movie using ColdFusion as
> "middleware" to do SQL selects and inserts from a database table. Some
> might argue that using session/client variables would be better... but
> for corporate reasons we wish to keep a 14 day (configurable of course)
> log
> I don't know if this is possible or not but I thought I would ask. I am
using Access and I would like to know if it is possible to return along with
my query the type of field that I am querying.
If this is MX, and you want to write some Java code, you can do it via the
JDBC metadata interface.
Che
> the page still bombs. this sucks.
Can you post the generated source code?
Nick
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
> - Error: document.PageSwitch2.Action has no properties
action is lower case.
Nick
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
Oliver
> If not can anyone recommend current hosts which are preferably MX
> enabled, a reasonable price & have msSQL.
If you want a UK-based one you might take a look at
http://www.cfmxhosting.co.uk
Nick
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings
> If you're running CFMX 6.1, I'd recommend taking a look at just running
CFMX
> on top of your existing JRun install
Is "CFMX for J2EE" now simply an install option for Enterprise then? Or is
it a different product version?
Nick
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsub
> We seem to be having trouble getting JRUN4 and CFMX to work together.
There may be a way of getting a standalone JRun to play nice with the one in
CFMX, but we couldn't figure it out. We gave up in the end and we're running
our pure Java apps through CFMX Enterprise's built-in JRun as well as ou
> Would you
> hire a web development shop to work on a project
> if they routinely did not use source control but relied
> on the developers to maintain informal source control?
That would depend on the complexity of the requirements (especially
interfaces to other systems/components), the depende
> I currently have an application that has a built in "heartbeat"... A 1x1
> pixel iframe that refreshes itself every 30 seconds.
Or just use an img tag? Works for me.
Nick
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
> Can someone steer me in the right direction to lear to use ImageMagick?
I guess you know about [EMAIL PROTECTED] ?
Nick
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
> I know, everyone hates pop-ups. I only use pop-ups to display larger
> images from thumbnails. Is it possible (via actionscript) to create a
> pop-up? How is it done if so?
getURL(url, "_blank") or getURL(url, existingWindowName) should do it.
But I always wonder, why is it that everyone suppos
> All I need to do is send in 1,1,1 to this method:
> public void setWidths(float[] widths) throws BadElementException {
float[] widths = {1.0,1.0,1.0};
setWidths(widths);
Any good?
Nick
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
Tom
> Check out servers alive at http://www.woodstone.nu/salive/
Thanks
Nick
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
Dave
> It seems to me that you'd be better off reducing the number of "moving
> parts" in this process. Why not write something that just runs on the
> server?
You're right (as usual), it's a bit of a mess. I was just being lazy &
trying to avoid writing any code.
Nick
[Todays Threads]
[Thi
We have been suffering from this problem with CFMX 6.1 that a lot of people
seem to have been having, where CF seizes up periodically. Every time this
happens we have to log in remotely and restart the CFMX services.
I'm trying to set up a system on my desktop that will detect that there's a
probl
Deanna
> Okay, so I was following along, but then you throw this out there. Huh? I
> thought that we're all supposed to start "thinking OO" to fully leverage
> CFC's. Am I wrong here?
No, of course you're not wrong - but there's more to CF than CFC's :-)
Nick
[Todays Threads]
[This Message]
> I'm not sure how 3 objects makes this any more likely than 2 objects.
I think Dwayne is referring to the fact that, once you've gone beyond having
one table or object class to model each real-world "thing", the criteria you
apply in each method for discovering your other artefacts are quite
diff
> 1) Will the SQL in my CF Templates still work after the migration?
Most likely not. Depends how standards-compliant your SQL is.
Date functions, string functions, data type conversions may give you a
problem.
SEQUENCEs will need to be changed to IDENTITY columns.
Nick
[Todays Threads]
[T
> You mean the lang environment variable on the server settings right?
I mean the Linux environment variable on the server, yes.
Nick
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
> ALL ACCENTED CHARACTERS that are passed to the server via web
> forms are converted to `y.
We had a similar problem in a JRun/Linux environment which was fixed by
setting the LANG environment variable appropriately.
Nick
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
I could well be wrong here, but I think maybe people are being misled by the
statement in the MM doc:
"Simply put, a race condition occurs anytime two threads (in this case, page
requests) try to write to the same data at the same time. "
That doesn't fully describe what's happening in their exam
> I think that writing to the registry will be the best solution for this.
cfregistry writes to the server's registry, not the client's.
Nick
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
> You don't have anything to worry about, Jeff. Users who have enabled
> ActiveX controls in Outlook will not be prompted before the Flash
> player and other ActiveX controls are loaded.
Does anyone in their right mind enable ActiveX controls in Outlook?
Nick
[Todays Threads]
[This Messa
Oliver
> Ideally I'd like to update the custom tag paths for the duration of a
> request and no longer.
>
> Anyone got any ideas?
Nasty hack, but but you could do something with ?
Or use CFCs or UDFs?
Nick
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Set
> How about trying to turn it back on and then off again to see if it still
> works for you?
>
> I've been trying for several days and my choice is always ignored.
Ah... just looked at it again... maybe I did something different ffrom you.
I chose "Text only email" from the dropdown. I don't think
> I don't want to deny anyone the choice of using html email but the option
of
> turning it off needs to be fixed. Everytime I uncheck the html preference
at
> houseoffusion.com it comes right back, never accepts that as my
preference.
Strange, I turned off the HTML option within the first two or
Joe> I wasnt able to find any clear documentation of the correct setup> for Multiple Instances of CFMX on JRun.Did you see this?http://livedocs.macromedia.com/coldfusion/6.1/htmldocs/clusteri.htm#wp102311Not a very full explanation I know.Nick
[Todays Threads] [This Message] [Subscription] [Fast U
Neil> Anyone know if and how you can compare two lists in SQL?imo the answer to all questions about lists in SQL is... don't store yourdata as lists!Not a very helpful statement I know. But you could read the lists intoanother table with a normalised structure and all of a sudden the querywould be
Robert> This is off topic somewhat, but I needed to move a SQL table to anotherSQL server. At first it seems the table did not import. So I deleted the oneon the new server and then imported the table I wanted (same name). Now theCF cart I created reads the records twice even though the table has o
MichaelHow about something likeSELECT sum(UNIQUE_VISITs) AS sys_sum, to_char(unique_date,'MM') AS monthno, to_char(unique_date,'MON') AS monthnameFROM unique_sessionsWHERE SITE = '#client#'GROUP BY monthno, monthNick
[Todays Threads] [This Message] [Subscription] [Fast Unsu
Brook
> Does any one know what the best way to pass a CF recordset via a
webservice
> to a desktop application developed in Delphi would be? Would I need to
> convert the recordset to an alternate format before sending it to a
desktop
> app via a webservice?
>
> Would I need to convert the query t
> Well, if you ever used CF3.0, which had NO proper way ...
What was the point of that post? POS, indeed.
My 2 cents worth: we've been using both CF and JRun for some time now. JSP,
on its own, has nothing to recommend it over CF, except that you can deploy
JSP apps on free standards-based softwa
We have had CFMX and JRun 4 coexisting peacefully on a W2K server for
months, blissfully ignorant of each other. Last week we upgraded CF to 6.1
and now it appears that JRun is interfering with CF somehow. CF was grinding
to a halt on a regular basis until we disabled the services for the JRun
serv
Hi everyone,
We rebuilt our server (CFMX/W2K), and CFCHART now falls over with the
following error.
Looks as if part of the JRE is missing.
Has anyone seen this/know how to fix it?
Thanks
Nick
The chart could not be generated due to an error in the graphing engine.
> I'm looking for a tree structure that can be expanded and collapsed much
> like Windows Explorer.
I'm surprised no-one has mentioned Joust. Not supported any more but still
pretty good, don't you think?
http://www.ivanpeters.com/index.htm?page=/joust/
Nick
PS I *love* Jochem's solution to the
> Sorry for the OT post, I'm a JSP newbie and need to know how I would do
>
>
> #cgi.server_name#
>
>
> on a JSP page?
<%=request.getServerName()%>
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
S
Isaac
> I'm not familiar... What's JMS?
Java Message Service - it's the J2EE spec for publisher-subscriber and
point-to-point messaging. Supported by JRun & other J2EE products.
As Sean says, it's quite hard work though.
Nick
~~~
> What I'm really wondering if there's a way to get something like J2EE
> session replication for the application scope.
I've wondered this too, but it seems that, because application data is part
of the servlet context, and the servlet context is unique to each JVM, there
is no built-in way to do
> Should be...max java class size issue?
It's reminiscent of a problem I've had using JSP custom tags in JRun, where
the compilation would fail if you had too many custom tag invocations in a
page. The only solution seemed to be to split the source up using JSP
includes - quite annoying at the tim
Sorry abot the fingers. What I was about to say was - is 600 and 400 the
result you *want* or that you don't want?
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription:
http://www.houseoffusion.co
- Original Message -
From: "JS" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, March 19, 2003 1:42 PM
Subject: OT: SQL Help
> I know there are some smart SQL people on this list,
> so I hope someone would be willing to help me with my
> problem.
>
> I have 2 tables
Bryan
This is exactly what we're talking about in the thread about MSDE.
MSDE (Microsoft Data Engine) is a baby SQL Server. It's on the Office XP CD
amongst other places.
Nick
- Original Message -
From: "Bryan Stevenson" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Tuesda
> That's the answer. The 120 day trial of SQLServer is handed out like
> lolly water by Microsoft at any of their promotions. The server expires
> after 120 days but I don't think the EM does.
Thanks, yes, I think that must be where I had it from before - I had a SQL
Server 7 book with an evaluat
Maybe you should take javadoc into consideration also.
> I wouldn't know of any such standard, but it is an issue I have
encountered as
> well. What I was wondering is if there would be any interest in defining
an XML
> schema for documentation and write some tools to create several derivative
> f
Jason
> >From what I can remember theres three option, Client Tools only, DB &
Client
> Tools, or DB Only.
It didn't give me any options. Is this MSDE or a proper SQL Server you've
got?
Nick
~|
Archives: http://www.houseoffus
> I wrote a "highlight keyword" function in JavaScript where I use the
> innerHtml property to get the body content into a variable. The script
works
> fine with IE 4.x and NS 7, but NS 4.x doesn't support this property.
>
> Does anybody know an equivalent property that works in NS 4.x. ?
There is
Thanks Jason.
So - stupid question - that means you have a file called
"C:\Program Files\Microsoft SQL Server\80\Tools\BINN\SQL Server Enterprise
Manager.MSC" ?
I don't. Where did you get it from?
Nick
~|
Archives: http://w
> It had one on Windows 98.
Well, let me rephrase that. I have MSDE on my W98 machine and also EM, and
if EM isn't part of MSDE where did I get it I wonder... don't remember.
Using isql for development is fine for a manly man like me ;-) but also I
wanted to use EM to administer a remote SQL Serv
Hi Paul
> msde has no GUI, its for manly men who use t-sql ;-)
It had one on Windows 98. Has that changed?
Nick
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription:
http://www.houseoffusion.com
I've been trying to install MSDE on XP Pro from the Office XP Pro CD.
The actual server part appears to have worked. I have some files under
Program Files\Microsoft SQL Server, in 2 folders called MSSQL and 80
respectively. The readme file in MSSQL is interesting but says nothing about
how to inst
Emmet
> if ((isNan(document.CartForm.myField.value)) ||
Try
if ((isNan(document.CartForm.elements[myField].value)) ||
Nick
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription:
http://www.house
Sorry, way OT by now.
> I took a seminar a while back on Section 508 and they explained that the
> word Handicap was given to disabled people because most disabled people at
> the time were Vietnam vets. The word handy capped means to had out a
> baseball call in and ask for a hand out.
What a b
> Or if you're a larger shop that has a vested interest in a "secret"
> methodology -- much like the people of Florence at one time gave
> Michaelangelo's David a FigLeaf, which only serves to create interest in
> what is covered up-- then any open publically known framework, Fusebox or
> otherwis
> Did you install JRun 4 SP1a ? (it breaks CF)
This only affects CFMX for J2EE, right? I hope there isn't a problem for
those of us running JRun separately alongside CFMX Pro?
Thanks
Nick
~|
Archives: http://www.houseoffusio
John
> To answer your question, our thinking is as follows: CFCs are not ready
for
> the big time.
>
> The reasons why have been discussed and debated for literally months by
tons
> of people on the various lists.
All the same, would you mind just giving a summary - for those of us who've
missed
Thanks Bud.
Any advance on that, anyone?
> CFHTTP has a problem with pages that are delivered in steps, such as
> a page that come back with "Please wait while your request is
> processed". It will get that first message and think the page is
> done. Not sure what you can do about it if anythi
We're using CFHTTP (CFMX) to get PDF documents translated to HTML by Adobe's
online service at http://access.adobe.com/perl/convertPDF.pl .
CFHTTP appears to be finishing reading the output before it's finished
coming back. I don't think it's timing out because we have the timeout set
to 600, both
> have u installed the service packs?
It's a new computer. It has SP1 installed. Is there another one?
Nick
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription:
http://www.houseoffusion.com/cf_l
> what exactly are ya tryin to do? search within those files?
Yes.
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription:
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
it will default to searching all of the local hard drives
> you have.
>
> have you tried this?
>
> tony
>
> -Original Message-
> From: Nick de Voil [mailto:[EMAIL PROTECTED]]
> Sent: Sunday, February 16, 2003 6:17 AM
> To: CF-Talk
> Subject: OT: Search
> URL fragments, used to reference named anchors, and query strings are not
> mutually exclusive in any respect. You can use either or both within a
> request. If you use both, the query string is processed by the application
> server, and the URL fragment is used by the browser to navigate to the
Hello everyone,
I'm sure this must be in the archives but I can't find it.
I've only had XP on my desktop machine for a couple of months.
My Documents > Search > A word or phrase in the file
doesn't work for me. It doesn't find the occurrences of the word. If I
search the same set of folders fo
Eric
> I need to recommend a J2EE server, or rather, I need this list too!
JRun works great for us (Linux, MySQL)
Nick
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription:
http://www.houseoffus
OK, I RTFM'ed and in Developing ColdFusion MX Applications with CFML I
find this:
THESAURUS Expands the search to include the word that you enter and its
synonyms. Collections do not have a thesaurus by default; to use this
feature you must build one.
SOUNDEX Expands the search to include the wo
I'm looking at this Verity doc
http://www.verity.com/pdf/white_papers/MK0348a_Discovery_WP.pdf
and I like the look of the THESAURUS, TYPO and SOUNDEX evidence operators.
Are these available via CF? If not, what do I have to do to get them and
what does it cost?
Thanks
Nick
__
Russ
> I'm trying to understand how to do simple pagination
This is called a next-n interface. There are quite a few web resources on
this if you do a search.
Basically you need to do a CFQUERY... CACHEDWITHIN... to get the data
efficiently, then display it on the page using variables to keep t
Dick
> On non-Windows platforms, you couldn't use ADO anyway. I imagine that
you
> could use the appropriate JDBC driver to do some of this stuff, directly
> from Java, but don't know enough about either Java or JDBC to say for
sure.
Dave's right, you can this with JDBC. Check out in particular
Jon
I haven't actually tried these out but I'd guess that
> My question is, is a good way to unload the
> object?
I don't think you need to unload it like that. It wouldn't cause the
memory to be released immediately anyway. The JVM's garbage collection
will take care of that for you.
> Also,
Chris
> A new client project of mine is going to requires some sort of dynamic
> web based Org Chart creation.
>
> Preferably a package that will integrate with CF.
>
> It would be nice if the interface were somewhat drag and drop.
Fig Leaf had a rather cool demo of exactly this based on Flash b
I've tried more relevant lists on this one but no luck.
This is a JRun 3.1 app. The login page submits a form and the action page
sets some session variables.
As you probably know, JRun handles sessions by setting a cookie called
"jsessionid".
All the testing so far has been done on W2K, W98 an
If you'd rather silently refresh the session of a user who's still in your
site, without prompting them, this can be done surprisingly easily with
JavaScript:
var dummy = new Image();
function keepAlive() {
dummy.src="servlet.KeepAlive?t=" + new Date.valueOf(); // timestamp
parameter to avoid
> Certainly still looking, you should put up a demo somewhere, looks like
I'm
> not the only one interested in something like that :-)
For now, I've put a link to a screenshot at http://www.ecstra.com (link at
bottom right of page).
It's part of a larger system so I would need to split out that
James
> I am looking for a way that I can allow site admins to edit CSS styles
to effect the look of a site, or page etc. It needs to be edited online.
Basically I want soEditor but for editing CSS styles instead of html :-)
>
> Anybody seen anything like this around ?
Yes, I have one I built,
> ( On a completely unrelated note, how can I view / set / change a
> classpath in Windows 2000? )
Control Panel - System - Advanced - Environment Variables
Nick
__
Your ad could be here. Monies from ads go to support these
Hi Neil,
> IMO, CFC's are a great OOP addition to ColdFusion; sure they may not fit
> into your Dictionary definition of OOP and they don't support
> polymorphism, but they are still an OOP concept - yes?
Yes. CFCs are the best thing since.. well, UDFs. Yes, they support
inheritance.
OOP is no
> If there's anyone you can imagine sliding down the Batpole, wouldn't it
be
> Steve Nelson?
Dave Watts maybe?
__
Signup for the Fusion Authority news alert and keep up with the latest news in
ColdFusion and related topics. htt
> XML is an implementation of SGML, which has been around for decades.
Yes indeed.
But I was giving an example of something changing the landscape.
We now have a universally accepted, simple, mostly logical, standard for
structuring data in a self-describing format that's both portable and
huma
> Can I ask for examples?
XML.
It doesn't change programming, but it sure changes the landscape.
btw my guess at first OO language would be Simula (1967)
Nick
__
Why Share?
Dedicated Win 2000 Server · PIII 800 / 256 MB RA
If anyone's got this UDF and is using the optional parameter, please
download the new version which fixes a bug in the Mastercard number
validation.
Thanks to Troy Pullis for spotting it.
Nick
__
Why Share?
Dedicated Win 2000
Adrian
> It is terrible (60 seconds) when run like this:
> SELECT a.f1,a.f2,b.ff1,b.ff2 FROM table1 a LEFT OUTER JOIN table2 b ON
a.id
> = b.id AND b.ff3 = 'T'
> WHERE b.mydate BETWEEN '3/4/2002' AND '3/6/2002' AND b.ff4 = 'somevalue'
How about the id fields in both tables, are they indexed?
Ni
Oracle, right?
AND eventdate >= SysDate
should do it
Nick
- Original Message -
From: Ian Vaughan <[EMAIL PROTECTED]>
To: CF-Talk <[EMAIL PROTECTED]>
Sent: Monday, January 14, 2002 11:48 AM
Subject: Coldfusion & Intelligent Queries ???
> Hi
>
> How do I modify my query below, so that
Chad,
I think you want
select distinct type from table where category = 'large'
Nick
- Original Message -
From: Chad Gray <[EMAIL PROTECTED]>
To: CF-Talk <[EMAIL PROTECTED]>
Sent: Saturday, January 05, 2002 3:19 PM
Subject: SQL question
> I have a table that i would like to pull some
House of Fusion has 2 lists dedicated to fusebox.
Also you could have a look in the archive (see URL at the bottom of
message)
Nick
__
Why Share?
Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
I
> Doesn't oracle support @@identity?
No.
> (What I DON'T know how to do is use that same value in subsequent
> queries
> without selecting it from the table I just inserted...)
Use sequencename.currval.
Nick
__
Dedicated Windo
Ben,
> Not to mention access to JSP tag and libraries (and other Java bits)
What the the future of CFML versus JSTL?
(For those who don't know, JSTL is the JSP Standard Tag Library, to be
included in a forthcoming J2EE spec. It lets you write JSP code that looks
uncannily like CF code)
Nick
__
Brad
> Can I use the alter table SQL statement to change the name of a table?
No, but you can do
CREATE TABLE b AS SELECT * FROM a (in some DBMS)
DROP TABLE a
which has the same effect.
Nick
__
Get Your Own Dedicated Windows
Dick
Does this help?
http://www.vbws.com/tutors/xsd/xsdvb.aspx
The nitty-gritty part seems to be
Dim schemaCache As MSXML2.XMLSchemaCache40
Set schemaCache = New MSXML2.XMLSchemaCache40
schemaCache.Add ,D:\schemas\mySchema.xsd
Dim doc As MSXML2.DOMDocument40
Set doc = New MSXML2.DOMDocumen
Anthony
Yes, but use "IS NULL" instead of "= NULL"
(TC.Status <> 'Closed') OR (TC.Status IS NULL)
Nick
~~
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www
That's it in Access and it's LOWER inn the other 2.
Nick
- Original Message -
From: Howie Hamlin <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, September 07, 2000 4:30 PM
Subject: Re: "lower" SQL function
> Try LCase
>
> Regards,
>
> Howie
>
> - Original Message -
>
know the syntax I need??
> >
> > No it doesn't make sense really. If you have more than one UserName for
> each
> > UserID, which I assume you do - otherwise the filtering would still be
> > working - then if you want a full list of UserNames you're bound to get
101 - 200 of 202 matches
Mail list logo