Freelancers Forum Messages on Monday September 10th 2007
Re: FN-FORUM: One for the SQL Experts
date posted 10th September 2007 23:32
Hi Craig,
I think this can be done in SQL using the INSTR() function. Try adding
something like this to your SQL and see if this works:
"AND INSTR(CONCAT(',',mailingGroupID), '," & strSupplierNumber...
Re: FN-FORUM: One for the SQL Experts
date posted 10th September 2007 23:32
couldn't you append a comma to myVar?
On 10 Sep 2007 22:34:00 -0000, Craig [EMAIL REMOVED] wrote:
>
> Thanks Paul,
>
> But I think that would fail if the numbers were 2,5,22,222,234 and were
> lookin...
RE: FN-FORUM: One for the SQL Experts
date posted 10th September 2007 22:58
Thanks Paul,
But I think that would fail if the numbers were 2,5,22,222,234 and were
looking for LIKE 2.
Craig
-----Original Message-----
As you might know from my posts I'm no SQL expert, but try...
Re: FN-FORUM: One for the SQL Experts
date posted 10th September 2007 22:19
As you might know from my posts I'm no SQL expert, but try:
strSQL = "SELECT COUNT(mailingListID) AS recount FROM tblMailingList
WHERE IsNull(unsubscribe) AND domainReg = '" & strDomain & "' AND
mail...
FN-FORUM: One for the SQL Experts
date posted 10th September 2007 22:03
Hi,
I'm trying to build a query in classic ASP to fire against a MySQL 5.0
server that can look inside a field value.
So far I have:-
strSQL = "SELECT COUNT(mailingListID) AS recount FROM tblMailing...
Re: FN-FORUM: MS Exchange SBS 2003
date posted 10th September 2007 20:53
Hi Kathy,
Replies in-line...
Lists (Kathy) wrote:
> Did you give your new MDBDATA directory/ies these permissions:
>
> Administrators: Full Control
> Authenticated Users: Read and Execute, List Fol...
Re: FN-FORUM: any punctuation experts out there?
date posted 10th September 2007 16:30
Hal MacLean wrote:
>
> I do despise seeing things badly written in shops though - take the
> running store in Bluewater, Kent - you can have trainers personalised
> to suit your taste. The sign go...
Re: FN-FORUM: any punctuation experts out there?
date posted 10th September 2007 16:20
Ah, but St. James's Palace is a name, and as such is able to be
written entirely as the owner wishes... much like Guy's Hospital, and
St. Thomas' Hospital (note the way those are written) - isn't...
RE: FN-FORUM: any punctuation experts out there?
date posted 10th September 2007 16:03
Johan wrote:
> If I remember my grammar correctly, those are not made up but
> actual rules. (I knew this thread would go into technicalities...)
Nope .. there's 3 (deliberate?) mistakes in Hal's bo...
RE: FN-FORUM: any punctuation experts out there?
date posted 10th September 2007 15:50
Quoting [EMAIL REMOVED] [EMAIL REMOVED]
[EMAIL REMOVED] [EMAIL REMOVED]
> You only add the ' at the end when the word ends with an s and needs
> ownership, e.g. James' book or Mr. Roberts' shirt....
Re: FN-FORUM: any punctuation experts out there?
date posted 10th September 2007 15:38
Quoting Juraj Seffer [EMAIL REMOVED]
> I will never understand why some people use DJ's instead of DJs when
> talking about more than one DJ. Annoying.
I agree that this looks ugly. And I never use...
Re: FN-FORUM: any punctuation experts out there?
date posted 10th September 2007 15:32
On 10/9/07 15:53, "Ben Johnson F (Neogic)" [EMAIL REMOVED]
wrote:
> I trust the several mistakes/made-up explanations in that page (its, Kris',
> Jess's) are deliberate? :)
>
> B
If I remember...
RE: FN-FORUM: any punctuation experts out there?
date posted 10th September 2007 15:17
Hal wrote:
> Reminds me of something my old boss used to do...
> http://rubble.heppell.net/%27/
I trust the several mistakes/made-up explanations in that page (its, Kris',
Jess's) are deliberate? :)...
RE: FN-FORUM: any punctuation experts out there?
date posted 10th September 2007 14:58
Matt wrote:
> You only add the ' at the end when the word ends with an s and
> needs ownership, e.g. James' book or Mr. Roberts' shirt.
Adding to this, note that in this (correct) case:
"Blackmore...
Re: FN-FORUM: any ideas??
date posted 10th September 2007 14:56
pam wrote:
>
> Hi all,
> I have a client ( a garage) who would like to set up a computer to allow
> their customers to be able to use 1 website to tax their car while they in
> the garage, does any o...
Re: FN-FORUM: any punctuation experts out there?
date posted 10th September 2007 14:52
On 10 Sep 2007 14:18:50 -0000, Hal MacLean [EMAIL REMOVED] wrote:
>
> Reminds me of something my old boss used to do...
>
> http://rubble.heppell.net/%27/
>
> and he wrote this just to keep us on our...
Re: FN-FORUM: any ideas??
date posted 10th September 2007 14:48
On 10 Sep 2007 14:05:26 -0000, pam [EMAIL REMOVED] wrote:
>
>
> Hi all,
> I have a client ( a garage) who would like to set up a computer to allow
> their customers to be able to use 1 website to tax...
Re: FN-FORUM: any ideas??
date posted 10th September 2007 14:47
Use some kind of firewall software (for example ZoneAlarm), then put =20
in 2 rules:
1st: Block all incoming and outgoing traffic
2nd: Allow traffic to domain (or IP to site)
Vi
Quoting pam [EM...
Re: FN-FORUM: any ideas??
date posted 10th September 2007 14:44
On 10 Sep 2007, at 15:05, pam wrote:
>
>
> Hi all,
> I have a client ( a garage) who would like to set up a computer to
> allow
> their customers to be able to use 1 website to tax their car while...
Re: FN-FORUM: any punctuation experts out there?
date posted 10th September 2007 14:42
Reminds me of something my old boss used to do...
http://rubble.heppell.net/%27/
and he wrote this just to keep us on our toes's
;-)
Hal
--
On 10 Sep 2007, at 15:04, Peter Scoins wrote:
>
>
> h...
Re: FN-FORUM: any ideas??
date posted 10th September 2007 14:41
You could use simple firewall rules. In effect the firewall would
disallow any access to other websites.
pam wrote:
> Hi all,
> I have a client ( a garage) who would like to set up a computer to all...
FN-FORUM: any ideas??
date posted 10th September 2007 14:28
Hi all,
I have a client ( a garage) who would like to set up a computer to allow
their customers to be able to use 1 website to tax their car while they in
the garage, does any one know how I could s...
Re: FN-FORUM: any punctuation experts out =?UTF-8?B?dGhlcmU/?=
date posted 10th September 2007 14:28
http://www.angryflower.com/bobsqu.gif
Explains All.... Angry Bob style!...
Re: FN-FORUM: any punctuation experts out there?
date posted 10th September 2007 14:15
Alex Townsend wrote:
> Carrie,
>
> The first option is correct.
>
Ta...
RE: FN-FORUM: any punctuation experts out there?
date posted 10th September 2007 14:15
First one.
You only add the ' at the end when the word ends with an s and needs
ownership, e.g. James' book or Mr. Roberts' shirt.
HTH,
Matt
-----Original Message-----
From: [EMAIL REMOVED] [EMAI...
Re: FN-FORUM: any punctuation experts out there?
date posted 10th September 2007 14:12
Carrie,
The first option is correct.
Its' would only be used if it were the possession of a group ( for
example Teachers' Handbook - the handbook for a group of teachers)
Me.
Quoting Carr...
FN-FORUM: any punctuation experts out there?
date posted 10th September 2007 14:07
Hi
sorry suffering from brain fade,
should it be:
Blackmore Vale Branch opens its doors for the first time
or
Blackmore Vale Branch opens its' doors for the first time
cheers
Carrie...
FN-FORUM: Anyone know qwiksite?
date posted 10th September 2007 13:49
I have a friend who is in need of someone to finish a site developed
using qwiksite.
http://www.dbqwiksite.com/index.html
Any takers? Can you email me off list.
Thanks...
Re: FN-FORUM: Displaying tabular data across recordsets.
date posted 10th September 2007 12:27
On 10 Sep 2007 11:51:48 -0000, Alex Townsend [EMAIL REMOVED] wrote:
>
> ORDER BY tblCourses.DisplayOrder, tblCourseAvailability.Location ASC
Bloody marvellous ... and damn simple! You've saved me a...
Re: FN-FORUM: Displaying tabular data across recordsets.
date posted 10th September 2007 12:16
Oh, and you want to do a second category of "Order By" for the =20
location, so your order by clause at the end will read...
ORDER BY tblCourses.DisplayOrder, tblCourseAvailability.Location ASC
Sorr...
Re: FN-FORUM: Displaying tabular data across recordsets.
date posted 10th September 2007 12:13
The alternative is to do the check on the recordset within the =20
server-side code (whether ASP or PHP)
Create two variables called (for example) old_val and new_val
At the start of the loop, set ne...
FN-FORUM: Displaying tabular data across recordsets.
date posted 10th September 2007 12:06
Hi
The Freelancers site was down when I posted this earlier, so apologies
if you've got it twice.
This follows on from my post last week. I've got the query working
fine (although I'm hoping it can...
Re: FN-FORUM: How widespread is Flash Player these =?UTF-8?B?ZGF5cz8=?=
date posted 10th September 2007 11:07
On 10 Sep 2007 10:07:15 -0000, Adam Reynolds [EMAIL REMOVED] wrote:
>
> Mike,
> Just wanted to say thank you for your input. It's changed my mind on
> Flash when it comes to accessibility.
>
> Ad...
Re: FN-FORUM: MS Exchange SBS 2003
date posted 10th September 2007 10:34
Did you give your new MDBDATA directory/ies these permissions:
Administrators: Full Control
Authenticated Users: Read and Execute, List Folder Contents, Read
Creator Owner: None
Server Operators: Mod...
Re: FN-FORUM: How widespread is Flash Player these days?
date posted 10th September 2007 10:31
Mike,
Just wanted to say thank you for your input. It's changed my mind on
Flash when it comes to accessibility.
Adam
Mike Duguid wrote:
>> Adam Reynolds:
>> Please do not sit there and state bulls...
FN-FORUM: MS Exchange SBS 2003
date posted 10th September 2007 08:46
I have an SBS 2003 Exchange server I'm setting up. I wanted to move the
store off drive C so using the directions from
http://support.microsoft.com/kb/821915/en-us I moved the various files
and set...
|
|