Hmm, a couple of meek suggestions from support, but nothing concrete...
Taking a snip from the WSDL file:
- s:element name=Address
- s:complexType
- s:sequence
s:element minOccurs=0 maxOccurs=1 name=Id type=s:string
/
s:element minOccurs=0 maxOccurs=1 name=AccountCode
Hi,
I have three queries that build a navigation system which is running really
slowly. This is because I haven't been able to combine the three queries
into one and therefore have to do nested loops which results in about 50
queries running for some sections of the site.
The three queries
You haven't told us which DB your using (although from memory I think it's
Access yes?)
Paul
I have three queries that build a navigation system which is
running really
slowly. This is because I haven't been able to combine the
three queries
into one and therefore have to do nested
Oh and the suggestion would be (if the circuits/menus don't change too
much):
Cache the queries
This way the database doesn't get hit so much. The content may change too,
but it might be useful to have, for example, a 10 or 30 minute cache on
those too. Just to take the load off.
Paul
Hi,
if you are using SQL Server, you could bung it all into an SP and let that
do the work, giving you a nice need end result
-Original Message-
From: Paul Johnston [mailto:[EMAIL PROTECTED]]
Sent: 16 January 2003 12:48
To: [EMAIL PROTECTED]
Subject: RE: [ cf-dev ] Confusing SQL
Oh and
you don't have the IIS lockdown tool running on this server by any chance?
Duncan Cumming
IT Manager
http://www.alienationdesign.co.uk
mailto:[EMAIL PROTECTED]
Tel: 0141 575 9700
Fax: 0141 575 9600
Creative solutions in a technical world
I thought that was an IIS issue (ie it was a bug which was useful to people,
so MS went and fixed it in a service pack).
You can install the url replacer isapi filter to do a similar thing
(http://www.pstruh.cz/help/urlrepl/library.htm )
where your new format would be:
The database is actually MySQL and whilst I could and should cache the
circuits query this is only hit once as I call the other 2 queries from
within the output of the circuits query and hence cannot cache them as
their result is dependent on a var which changes each time the loop is
executed.
I think you are doing the best you can with mySQL considering you have
no SP's, views etc... :-)
-Original Message-
From: Dave Phipps [mailto:[EMAIL PROTECTED]]
Sent: 16 January 2003 13:09
To: [EMAIL PROTECTED]
Subject: RE: [ cf-dev ] Confusing SQL
The database is actually MySQL and
?
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]
Sent: 16 January 2003 13:02
To: [EMAIL PROTECTED]
Subject: Re: [ cf-dev ] Delivering files
you don't have the IIS lockdown tool running on this server by any chance?
Duncan Cumming
IT Manager
which I might add will change in a future official release...
- Original Message -
From: Robertson-Ravo, Neil (RX) [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, January 16, 2003 1:06 PM
Subject: RE: [ cf-dev ] Confusing SQL
I think you are doing the best you can with
The database is actually MySQL and whilst I could and should
cache the
circuits query this is only hit once as I call the other 2
queries from
within the output of the circuits query and hence cannot
cache them as
their result is dependent on a var which changes each time
the loop
i meant the URLScan thingy, which checks for various insecure URL's. it
doesn't like things like full stops in a directory name, which is what the
url you've given looks like.
Duncan Cumming
IT Manager
http://www.alienationdesign.co.uk
mailto:[EMAIL PROTECTED]
Tel: 0141 575 9700
Fax: 0141 575
Is that something on a Windows SP or is it third party?
If it's the former how do I know it's on and can I turn it off and if so,
HOW?
Paolo
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]
Sent: 16 January 2003 13:17
To: [EMAIL PROTECTED]
Subject: RE: [ cf-dev ]
http://www.microsoft.com/technet/security/tools/tools/urlscan.asp?frame=true
justin
-Original Message-
From: Paolo Piponi [mailto:[EMAIL PROTECTED]]
Sent: 16 January 2003 13:27
To: '[EMAIL PROTECTED]'
Subject: RE: [ cf-dev ] Delivering files
Is that something on a Windows SP or
http://www.microsoft.com/technet/treeview/default.asp?url=/technet/security/tools/tools/urlscan.asp
It's not included by default with Windows. Take a look for a folder like
\%Windows Folder%\System32\inetsrv\urlscan\ or do a search for urlscan.dll.
Duncan Cumming
IT Manager
This may sound like a strange request but how would i get CFMX to play a wav
file on the server?
Would cfexecute work or will I have to write a little Java Program or CFX
tag - shouldn't think that that would be too difficult.
Thanks
Giles
--
** Archive:
yep, but as in a post a while ago, they have a long way to go before they
are anywhere near Enterprise level, still good though!
-Original Message-
From: Tom Smith [mailto:[EMAIL PROTECTED]]
Sent: 16 January 2003 13:15
To: [EMAIL PROTECTED]
Subject: Re: [ cf-dev ] Confusing SQL
which I
Sounded like an exciting possibility but unfortunately a search for
urlscan anywhere on the system did not come up with anything. )^;
The problem could be a service pack, of course. I'll need to check out
versions between servers.
Paolo
-Original Message-
From: [EMAIL PROTECTED]
Nope. All systems are W2000 Server 5.00.2195 SP3. Arg!
It is possible that CFMX could change a setting in IIS but unfortunately
I'll need a fresh machine to test that now as an uninstall of CFMX won't do.
Paolo
-Original Message-
From: Paolo Piponi
Sent: 16 January 2003 13:45
To:
I would have thought that CFEXECUTE would work fine.
Won't ask why you need it.
Paolo
-Original Message-
From: Giles Roadnight [mailto:[EMAIL PROTECTED]]
Sent: 16 January 2003 13:35
To: [EMAIL PROTECTED]
Subject: [ cf-dev ] Playing Wav Files
This may sound like a strange request but
Hi
Sorry for the off topic post.
We use SoEditor Lite (with the CSS support) to edit cfm files that are
included in our home page.
The problem is that if we give a table in SoEditor a blue background it
looks blue in soEditor but when the file is included in the home page it
turns to the
how are you defining the style sheet for the normal HTML? is it a custom
style or is it a redefined HTML tag?
-Original Message-
From: Giles Roadnight [mailto:[EMAIL PROTECTED]]
Sent: 16 January 2003 13:58
To: [EMAIL PROTECTED]
Subject: [ cf-dev ] OT: ByPassing Style Sheets
Hi
Sorry
The styles are all in a separate CSS file. Don't really know what you mean
by the second Question.
You can see the home page here:
http://dev.scottishproperty.co.uk
The problem is that the Cambuslang Investment Park bit on the left with the
picture of the property should have a blue background
Do you mean like this? This works on my system. The second table has a style
that overrides the class.
style
.table{background:00}
/style
table class=table
trtdTEST/td/tr
/table
br
table class=table style=background:ff
trtdTEST/td/tr
/table
-Original
This might seem pedantic Giles but do you actually need to put a table in --
couldn't you just use SoEditor for the content of the table... if could also
save your client going off and doing frightful things with the tables!
- Original Message -
From: Giles Roadnight [EMAIL PROTECTED]
What I mean is this :
TD {
background:00
}
.td {
background:00
{
The former is a redefinition of the HTML tag itself which in turn will
change all TD's to have that style. The latter is a custom style which you
have given the name TD.
-Original
hence...'Cascading'
-Original Message-
From: Matt Horn [mailto:[EMAIL PROTECTED]]
Sent: 16 January 2003 14:14
To: [EMAIL PROTECTED]
Subject: Re: [ cf-dev ] OT: ByPassing Style Sheets
you can override the .css class by including a style attreibute in the
actual HTML tag
At 13:57
yes
hence Cascading
At 14:12 16/01/2003 +, you wrote:
hence...'Cascading'
-Original Message-
From: Matt Horn [mailto:[EMAIL PROTECTED]]
Sent: 16 January 2003 14:14
To: [EMAIL PROTECTED]
Subject: Re: [ cf-dev ] OT: ByPassing Style Sheets
you can override the .css class by
I don't know, could we do the background colour with spans instead?
It is just a nice way to format the layout of the ad. This part of the
system is not open to clients, it is an internal admin area so it is not as
if anyone can get in there and make a horrible HTML mess.
Appreciate what you are
yep, but as in a post a while ago, they have a long way to go
before they are anywhere near Enterprise level, still good though!
Where be this post? Anyone got any other info on enterprise-level
hosting with MySQL?
Tim.
---
OUR NEW SITE
i'll did it out for ya :-) I am sure it was on CF-TALK..
-Original Message-
From: Tim Blair [mailto:[EMAIL PROTECTED]]
Sent: 16 January 2003 14:30
To: [EMAIL PROTECTED]
Subject: RE: [ cf-dev ] Confusing SQL
yep, but as in a post a while ago, they have a long way to go
before they
yes, search the archives for WOT: MySQL in the Enterprise
-Original Message-
From: Robertson-Ravo, Neil (RX)
[mailto:[EMAIL PROTECTED]]
Sent: 16 January 2003 14:30
To: '[EMAIL PROTECTED]'
Subject: RE: [ cf-dev ] Confusing SQL
i'll did it out for ya :-) I am sure it was on CF-TALK..
I would have thought that CFEXECUTE would work fine.
Won't ask why you need it.
Giles is too embarrased to tell you why he needs this, but I do like to see
him cringe.
Basically, he wants to set up a web cam at home so he can see what his dogs
are up to in his study when he is in the
Ha! thats great!
-Original Message-
From: Paddy McKay [mailto:[EMAIL PROTECTED]]
Sent: 16 January 2003 15:07
To: [EMAIL PROTECTED]
Subject: Re: [ cf-dev ] Playing Wav Files
I would have thought that CFEXECUTE would work fine.
Won't ask why you need it.
Giles is
I hate to the think of the psychological effects that will have on the poor
critters! You can just imagine them running round the house trying to find
their masters voice.
Great idea though.
-Original Message-
From: Paddy McKay [mailto:[EMAIL PROTECTED]]
Sent: 16 January 2003 15:07
To:
If Only I had thought of it 6 months ago!! I don't have flat mates any more
as we will be moving soon.
- Original Message -
From: Rich Wild [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, January 16, 2003 3:13 PM
Subject: RE: [ cf-dev ] Playing Wav Files
I'm going to set that up
Well with voice-over-IP you'd have a lot more fun. Especially if you have it
fed to every room of the house. Oh, that was Big Brother.
Paolo
-Original Message-
From: Rich Wild [mailto:[EMAIL PROTECTED]]
Sent: 16 January 2003 15:13
To: '[EMAIL PROTECTED]'
Subject: RE: [ cf-dev ] Playing
input type=button class=subscribersButton value=test Button
onMouseOver=this.className='subscribersButtonMouseOver'
onMouseOut=this.className='subscribersButton'
Matt
At 16:16 16/01/2003 +, you wrote:
Hopefully a quick one as it's getting on for that time of day.
Can I change the stlye
Does anyone know how to reset the IP address CFMX allows connections from?
Restarting CFMX doesn't appear to work. Do you have to restart the server?
Paul
---
Paul Johnston
PJ Net Solutions Ltd
http://www.pjnetsolutions.com
[EMAIL PROTECTED]
+44 (0)7866
Does anyone know how to reset the IP address CFMX allows connections
from?
There's a file in the CFMX folder somewhere that has the IP address in
it. You have to manually edit the file and then restart the service. I
could have sworn it was license.properties, but that doesn't have an
IP address
Licence.properties is correct
There's a file in the CFMX folder somewhere that has the IP
address in it. You have to manually edit the file and then
restart the service. I could have sworn it was
license.properties, but that doesn't have an IP address in
it on my machine.
--
**
42 matches
Mail list logo