This is a multi-part message in MIME format.
--------------D7FD495CFC2DFABAD2D5A4A5
Content-Type: multipart/alternative;
boundary="------------675669474CA13BA839D12DE5"
--------------675669474CA13BA839D12DE5
Content-Type: text/plain; charset=us-ascii; x-mac-type="54455854";
x-mac-creator="4D4F5353"
Content-Transfer-Encoding: 7bit
If it's an access database, try putting #'s around the date, actually, you may need to
put ##'s to escape the #. If its SQL Server put ' ' around the date.
Nick
"AustralianAccommodation.com Pty. Ltd." wrote:
> I has an articles database and i am wanting to be able to search the
> database for articles that were published on a specified date. The dates are
> selected from a drop down list populated from the dates of each record in
> the articles table.
>
> The following code is taken from my action page however when ever i pass a
> date from the search form to the action page i receive an error message
> saying
>
> " Error Diagnostic Information
> ODBC Error Code = 22012 (Division by zero)
>
> [Microsoft][ODBC Microsoft Access Driver]Division by zero (null)
>
> Data Source = "citicentre"
>
> SQL = "SELECT * FROM articles WHERE articleid not like 0 AND ArticleDate
> like 05/07/00"
> "
> The action page code is as follws the dates in the search form page appear
> using the format of #DateFormat(ArticleDate, 'DD/MM/YY')# may be this is
> something to do with the problem
>
> your assistance would be appreciated
>
> <CFQUERY DATASOURCE="citicentre" NAME="articles">
> SELECT *
> FROM articles
> WHERE articleid not like 0
> <cfif articletitle is not "">
> AND articletitle like '#form.articletitle#%'
> </cfif>
> <cfif articledate gt 0>
> AND ArticleDate like #DateFormat(ArticleDate, 'DD/MM/YY')#
> </cfif>
>
> Kind Regards
>
> Claude Raiola (Director)
> AustralianAccommodation.com Pty. Ltd.
> Website: www.AustralianAccommodation.com
> Email: [EMAIL PROTECTED]
>
> ------------------------------------------------------------------------------
> Archives: http://www.mail-archive.com/[email protected]/
> To Unsubscribe visit
>http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
>message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
--------------675669474CA13BA839D12DE5
Content-Type: text/html; charset=us-ascii
Content-Transfer-Encoding: 7bit
<!doctype html public "-//w3c//dtd html 4.0 transitional//en">
<html>
If it's an access database, try putting #'s around the date, actually,
you may need to put ##'s to escape the #. If its SQL Server put '
' around the date.
<p>Nick
<br>
<br>
<br>
<p>"AustralianAccommodation.com Pty. Ltd." wrote:
<blockquote TYPE=CITE>I has an articles database and i am wanting to be
able to search the
<br>database for articles that were published on a specified date. The
dates are
<br>selected from a drop down list populated from the dates of each record
in
<br>the articles table.
<p>The following code is taken from my action page however when ever i
pass a
<br>date from the search form to the action page i receive an error message
<br>saying
<p>" Error Diagnostic Information
<br>ODBC Error Code = 22012 (Division by zero)
<p>[Microsoft][ODBC Microsoft Access Driver]Division by zero (null)
<p>Data Source = "citicentre"
<p>SQL = "SELECT * FROM articles WHERE articleid not like 0 AND ArticleDate
<br>like 05/07/00"
<br>"
<br>The action page code is as follws the dates in the search form page
appear
<br>using the format of #DateFormat(ArticleDate, 'DD/MM/YY')# may be this
is
<br>something to do with the problem
<p>your assistance would be appreciated
<p> <CFQUERY DATASOURCE="citicentre" NAME="articles">
<br> SELECT *
<br> FROM articles
<br> WHERE articleid not like 0
<br> <cfif articletitle is not "">
<br> AND articletitle like '#form.articletitle#%'
<br> </cfif>
<br> <cfif articledate gt 0>
<br> AND ArticleDate like
#DateFormat(ArticleDate,
'DD/MM/YY')#
<br> </cfif>
<p>Kind Regards
<p>Claude Raiola (Director)
<br>AustralianAccommodation.com Pty. Ltd.
<br>Website: www.AustralianAccommodation.com
<br>Email: [EMAIL PROTECTED]
<p>------------------------------------------------------------------------------
<br>Archives: <a
href="http://www.mail-archive.com/[email protected]/">http://www.mail-archive.com/[email protected]/</a>
<br>To Unsubscribe visit <a
href="http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk">http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk</a>
or send a message to [EMAIL PROTECTED] with 'unsubscribe'
in the body.</blockquote>
</html>
--------------675669474CA13BA839D12DE5--
--------------D7FD495CFC2DFABAD2D5A4A5
Content-Type: text/x-vcard; charset=us-ascii;
name="nickslay.vcf"
Content-Transfer-Encoding: 7bit
Content-Description: Card for Nick Slay
Content-Disposition: attachment;
filename="nickslay.vcf"
begin:vcard
n:Slay;Nick
tel;cell:0414 810284
tel;home:02 4381 0284
tel;work:02 4381 0284
x-mozilla-html:FALSE
url:http://www.webbods.com.au
org:Webbods Pty Ltd
adr:;;PO Box 4054;Copacabana;NSW;2251;Australia
version:2.1
email;internet:[EMAIL PROTECTED]
title:Technical Director
x-mozilla-cpt:;3
fn:Nick Slay
end:vcard
--------------D7FD495CFC2DFABAD2D5A4A5--
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
