Re: [WebDNA] Upload file to mysql

This WebDNA talk-list message is from

2017


It keeps the original formatting.
numero = 113488
interpreted = N
texte = 1083 --Apple-Mail=_E1264B20-BF32-48DF-900C-E5B4C109559D Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset=utf-8 Yes, PHP has a nice escape routine. I should write one for WebDNA as I would use it, at the moment I just = use GREP for a few characters. Kind regards Stuart Tremain Pharoah Lane Software AUSTRALIA webdna@idfk.com.au > On 22 Mar 2017, at 00:17, Brian Boegershausen = wrote: >=20 > Thank stuart. > After a few more painful hours of tinkering, i decided to write the = upload/download pages in php.=20 > Works great now. All the escape context is built right in. > Not my favorite option, but why reinvent the wheel. >=20 >=20 > Brian Boegershausen >=20 >=20 >=20 > From: Stuart Tremain > Sent: Monday, March 20, 10:58 PM > Subject: Re: [WebDNA] Upload file to mysql > To: WebDNA Talk List >=20 > http://php.net/manual/en/mysqli.real-escape-string.php = > Characters encoded are NUL (ASCII 0), \n, \r, \, ', ", and Control-Z. >=20 >=20 > Kind regards >=20 > Stuart Tremain >=20 > Pharoah Lane Software >=20 > AUSTRALIA >=20 > webdna@idfk.com.au >=20 >=20 >=20 >=20 >=20 >> On 21 Mar 2017, at 13:51, Brian Boegershausen > wrote: >>=20 >> You think i should [url]ize the string? >> Then i can look for %0A and things like that. >>=20 >> Brian Boegershausen >>=20 >>=20 >>=20 >>=20 >>=20 >> On Mon, Mar 20, 2017 at 10:49 PM -0400, "Stuart Tremain" = > wrote: >=20 > I think that is where your problem lies. >=20 > https://dev.mysql.com/doc/refman/5.7/en/string-literals.html = > The MySQL manual page for strings says: >=20 > \0 An ASCII NUL (0x00) character. >=20 > \' A single quote (=E2=80=9C'=E2=80=9D) character. >=20 > \" A double quote (=E2=80=9C"=E2=80=9D) character. >=20 > \b A backspace character. >=20 > \n A newline (linefeed) character. >=20 > \r A carriage return character. >=20 > \t A tab character. >=20 > \Z ASCII 26 (Control-Z).=20 >=20 > \\ A backslash (=E2=80=9C\=E2=80=9D) character. >=20 > \% A =E2=80=9C%=E2=80=9D character.=20 >=20 > \_ A =E2=80=9C_=E2=80=9D character.=20 >=20 >=20 >=20 >=20 >=20 > Kind regards >=20 > Stuart Tremain >=20 > Pharoah Lane Software >=20 > AUSTRALIA >=20 > webdna@idfk.com.au >=20 >=20 >=20 >=20 >=20 >> On 21 Mar 2017, at 13:42, > > wrote: >>=20 >> I added the ; into my convertchars database. Flushed=E2=80=A6 still = having an issue. >>=20 >> I think I need a bigger list of escape characters L >>=20 >> =20 >> =20 >> =20 >> From: Stuart Tremain [mailto:webdna@idfk.com.au = ]=20 >> Sent: Monday, March 20, 2017 9:45 PM >> To: WebDNA Talk List > >> Subject: Re: [WebDNA] Upload file to mysql >>=20 >> =20 >> That is a problem with a character causing MySQL to fail. >>=20 >> =20 >> Looking at your conversion db it looks like you have covered = everything except for ; (semicolon) >>=20 >> =20 >> There may be something else as well. >>=20 >> =20 >> Kind regards >>=20 >> =20 >> Stuart Tremain >>=20 >> Pharoah Lane Software >>=20 >> AUSTRALIA >>=20 >> webdna@idfk.com.au >> =20 >> =20 >> =20 >> =20 >> =20 >>> On 21 Mar 2017, at 12:16, > > wrote: >>>=20 >>> =20 >>> ERROR TEXT: You have an error in your SQL syntax; check the manual = that corresponds to your MySQL server version for the right syntax to = use near ''\%PDF-1.5 \%=EF=BF=BD=EF=BF=BD=EF=BF=BD=EF=BF=BD 1 0 obj < >>>=20 >>> =20 >>> =20 >>> When I look in the errorlog.txt file, the =EF=BF=BD characters are = the following symbols. >>>=20 >>> =C3=A2=C3=A3=C3=8F=C3=93 >>>=20 >>> =20 >>> =20 >>> From: Stuart Tremain [mailto:webdna@idfk.com.au = ]=20 >>> Sent: Monday, March 20, 2017 9:03 PM >>> To: WebDNA Talk List > >>> Subject: Re: [WebDNA] Upload file to mysql >>>=20 >>> =20 >>> What is the error ? >>>=20 >>> =20 >>> Kind regards >>>=20 >>> =20 >>> Stuart Tremain >>>=20 >>> Pharoah Lane Software >>>=20 >>> AUSTRALIA >>>=20 >>> webdna@idfk.com.au >>> =20 >>> =20 >>> =20 >>> =20 >>> =20 >>>> On 21 Mar 2017, at 12:00, Brian Boegershausen = > wrote: >>>>=20 >>>> =20 >>>> Mysql error. >>>>=20 >>>> =20 >>>> Brian Boegershausen >>>>=20 >>>> =20 >>>> =20 >>>>=20 >>>>=20 >>>>=20 >>>> On Mon, Mar 20, 2017 at 8:59 PM -0400, "Stuart Tremain" = > wrote: >>>>=20 >>>>> Brian, when you say it chokes, do you mean that WebDNA stalls or = do you get a MySQL error message ? >>>>>=20 >>>>> =20 >>>>> =20 >>>>> Kind regards >>>>>=20 >>>>> =20 >>>>> Stuart Tremain >>>>>=20 >>>>> Pharoah Lane Software >>>>>=20 >>>>> AUSTRALIA >>>>>=20 >>>>> webdna@idfk.com.au >>>>> =20 >>>>> =20 >>>>> =20 >>>>> =20 >>>>> =20 >>>>>> On 21 Mar 2017, at 11:15, > > wrote: >>>>>>=20 >>>>>> =20 >>>>>> Hi Stewart, >>>>>>=20 >>>>>> I have my content field set to MEDIUMBLOB which allows for 16mb = max files. >>>>>>=20 >>>>>> So far, I am using files around 100kb, so I am not reaching the = max yet. >>>>>>=20 >>>>>> =20 >>>>>> My query writes all the data fields and uploads .txt files, but = once I change to a file like a PDF, it chokes. >>>>>>=20 >>>>>> =20 >>>>>> [showif [referer]^file_manager.dna] >>>>>>=20 >>>>>> [FormVariables] >>>>>>=20 >>>>>> [showif [name]^filename] >>>>>>=20 >>>>>> [text show=3DF]TheFileNM=3D[Middle = StartAfter=3Dfilename=3D"&EndBefore=3D"][name][/middle][/text] >>>>>>=20 >>>>>> [/showif] >>>>>>=20 >>>>>> [showif [name]^CPK] >>>>>>=20 >>>>>> [text show=3DF]CPK=3D[value][/text] >>>>>>=20 >>>>>> [/showif] >>>>>>=20 >>>>>> [showif [name]^JPK] >>>>>>=20 >>>>>> [text show=3DF]JPK=3D[value][/text] >>>>>>=20 >>>>>> [/showif] >>>>>>=20 >>>>>> [/FormVariables] >>>>>>=20 >>>>>> =20 >>>>>> [hideif [TheFileNM]=3D] >>>>>>=20 >>>>>> [hideif [CPK]=3D] >>>>>>=20 >>>>>> [hideif [JPK]=3D] >>>>>>=20 >>>>>> [FormVariables] >>>>>>=20 >>>>>> [showif [name]^"thefile"] >>>>>>=20 >>>>>> [SQLExecute conn_ref=3DTheBlueBiller&result_var=3DUPLOAD_INS] >>>>>>=20 >>>>>> INSERT INTO UPLOAD >>>>>>=20 >>>>>> (FILE_ID, COMPANY_ID, CLIENT_ID, JOB_ID, NAME, CONTENT, = ROW_ADDED_DTTM) >>>>>>=20 >>>>>> VALUES ('', '[LOGIN_COMPANY_ID]', '[CPK]', '[JPK]', = '[TheFileNM]', '[convertchars = db=3Ddatabases/upload.db][value][/convertchars]', '[date %Y-%m-%d = %H:%M:%S]') >>>>>>=20 >>>>>> [/SQLExecute] >>>>>>=20 >>>>>> [/showif] >>>>>>=20 >>>>>> [/FormVariables] >>>>>>=20 >>>>>> [/hideif] >>>>>>=20 >>>>>> [/hideif] >>>>>>=20 >>>>>> [/hideif] >>>>>>=20 >>>>>> =20 >>>>>> [!]=3D=3D=3D=3D=3D=3D=3D=3DUPLOAD.DB FILE------------[/!] >>>>>>=20 >>>>>> FROM TO >>>>>>=20 >>>>>> ' \' >>>>>>=20 >>>>>> " \" >>>>>>=20 >>>>>> \ \\ >>>>>>=20 >>>>>> % \% >>>>>>=20 >>>>>> =20 >>>>>> From: Stuart Tremain [mailto:webdna@idfk.com.au = ]=20 >>>>>> Sent: Monday, March 20, 2017 6:43 PM >>>>>> To: WebDNA Talk List > >>>>>> Subject: Re: [WebDNA] Upload file to mysql >>>>>>=20 >>>>>> =20 >>>>>> Hi Brian >>>>>>=20 >>>>>> =20 >>>>>> I have not done that, but providing your MySQL field is LONGBLOB = all should work.=20 >>>>>>=20 >>>>>> =20 >>>>>> Also to be able to insert images that are bigger than 1MB you = have to increase the max_allowed_packed option in the server = configuration file. >>>>>>=20 >>>>>> =20 >>>>>> I use Navicat to write all my queries and then copy & paset the = query into my WebDNA doc. Navicat makes writing & debugging fast. >>>>>>=20 >>>>>> =20 >>>>>> Kind regards >>>>>>=20 >>>>>> =20 >>>>>> Stuart Tremain >>>>>>=20 >>>>>> Pharoah Lane Software >>>>>>=20 >>>>>> AUSTRALIA >>>>>>=20 >>>>>> webdna@idfk.com.au >>>>>> =20 >>>>>> =20 >>>>>> =20 >>>>>> =20 >>>>>> =20 >>>>>>> On 21 Mar 2017, at 07:55, Brian Boegershausen = > wrote: >>>>>>>=20 >>>>>>> =20 >>>>>>> Anyone successfully upload a file to a mysql db? >>>>>>> I can upload a text file but that is it. >>>>>>> Jpg and gif fail. >>>>>>>=20 >>>>>>> Unbuntu 14 >>>>>>> Webdna 8.2 >>>>>>> Mysql 5.5 >>>>>>>=20 >>>>>>> =20 >>>>>>> Brian Boegershausen >>>>>>>=20 >>>>>>> =20 >>>>>>> =20 >>>>>>> --------------------------------------------------------- This = message is sent to you because you are subscribed to the mailing list . = To unsubscribe, E-mail to: archives: = http://mail.webdna.us/list/talk@webdna.us = Bug Reporting: = support@webdna.us >>>>>>=20 >>>>>> =20 >>>>>>=20 >>>>>> =20 >>>>>> Virus-free.=20 >>>>>> www.avg.com = >>>>>> --------------------------------------------------------- This = message is sent to you because you are subscribed to the mailing list . = To unsubscribe, E-mail to: archives: = http://mail.webdna.us/list/talk@webdna.us = Bug Reporting: = support@webdna.us >>>>>> --------------------------------------------------------- This = message is sent to you because you are subscribed to the mailing list . = To unsubscribe, E-mail to: archives: = http://mail.webdna.us/list/talk@webdna.us = Bug Reporting: = support@webdna.us >>>>>=20 >>>>> =20 >>>>>=20 >>>>> --------------------------------------------------------- This = message is sent to you because you are subscribed to the mailing list . = To unsubscribe, E-mail to: archives: = http://mail.webdna.us/list/talk@webdna.us = Bug Reporting: = support@webdna.us >>>>=20 >>>> --------------------------------------------------------- This = message is sent to you because you are subscribed to the mailing list . = To unsubscribe, E-mail to: archives: = http://mail.webdna.us/list/talk@webdna.us = Bug Reporting: = support@webdna.us >>>=20 >>> =20 >>>=20 >>> =20 >>> Virus-free.=20 >>> www.avg.com = >>> --------------------------------------------------------- This = message is sent to you because you are subscribed to the mailing list . = To unsubscribe, E-mail to: archives: = http://mail.webdna.us/list/talk@webdna.us = Bug Reporting: = support@webdna.us >>> --------------------------------------------------------- This = message is sent to you because you are subscribed to the mailing list . = To unsubscribe, E-mail to: archives: = http://mail.webdna.us/list/talk@webdna.us = Bug Reporting: = support@webdna.us >>=20 >> =20 >>=20 >> =20 >> Virus-free.=20 >> = >> www.avg.com >>=20 >> --------------------------------------------------------- This = message is sent to you because you are subscribed to the mailing list . = To unsubscribe, E-mail to: archives: = http://mail.webdna.us/list/talk@webdna.us = Bug Reporting: = support@webdna.us >> --------------------------------------------------------- This = message is sent to you because you are subscribed to the mailing list . = To unsubscribe, E-mail to: archives: = http://mail.webdna.us/list/talk@webdna.us = Bug Reporting: = support@webdna.us >=20 > --------------------------------------------------------- This message = is sent to you because you are subscribed to the mailing list . To = unsubscribe, E-mail to: archives: = http://mail.webdna.us/list/talk@webdna.us = Bug Reporting: = support@webdna.us = --------------------------------------------------------- This message = is sent to you because you are subscribed to the mailing list . To = unsubscribe, E-mail to: archives: = http://mail.webdna.us/list/talk@webdna.us = Bug Reporting: = support@webdna.us > --------------------------------------------------------- This message = is sent to you because you are subscribed to the mailing list . To = unsubscribe, E-mail to: archives: = http://mail.webdna.us/list/talk@webdna.us Bug Reporting: = support@webdna.us >=20 > --------------------------------------------------------- This message = is sent to you because you are subscribed to the mailing list . To = unsubscribe, E-mail to: archives: = http://mail.webdna.us/list/talk@webdna.us Bug Reporting: = support@webdna.us --Apple-Mail=_E1264B20-BF32-48DF-900C-E5B4C109559D Content-Transfer-Encoding: quoted-printable Content-Type: text/html; charset=utf-8 Yes, PHP has a nice escape routine.

I should write one for WebDNA as I = would use it, at the moment I just use GREP for a few = characters.

Kind regards

Stuart Tremain
Pharoah Lane Software
AUSTRALIA






On 22 Mar 2017, at 00:17, Brian Boegershausen <brian@endeavotech.com> wrote:

Thank stuart.
After a few more painful hours of tinkering, i decided to write the = upload/download pages in php.
Works great now. All the escape context is built right in.
Not my favorite option, but why reinvent the wheel.


Brian Boegershausen



From: Stuart Tremain
Sent: Monday, March 20, 10:58 PM
Subject: Re: [WebDNA] Upload file to mysql
To: WebDNA Talk List

http://php.net/manual/en/mysqli.real-escape-string.php

Characters encoded are NUL (ASCII 0), \n, \r, \, ', ", and Control-Z.

Kind regards

Stuart Tremain

Pharoah Lane Software

AUSTRALIA

webdna@idfk.com.au





On 21 Mar 2017, at = 13:51, Brian Boegershausen <brian@endeavotech.com> wrote:

You think i should [url]ize the string?
Then i can look for %0A and things like that.

Brian Boegershausen




On Mon, Mar 20, 2017 at 10:49 PM -0400, "Stuart Tremain" = <webdna@idfk.com.au> wrote:


I think that is where your problem lies.

https://dev.mysql.com/doc/refman/5.7/en/string-literals.html

The MySQL manual = page for strings says:

\0   An ASCII NUL (0x00) character.

\'   A single quote (=E2=80=9C'=E2=80=9D) = character.

\"   A double quote (=E2=80=9C"=E2= =80=9D) character.

\b   A = backspace character.

\n   A = newline (linefeed) character.

\r   A = carriage return character.

\t   A tab = character.

\Z   ASCII 26 = (Control-Z). 

\\   A = backslash (=E2=80=9C\=E2=80=9D) character.

\%   A =E2=80=9C%=E2=80=9D character. 

\_   A =E2=80=9C_=E2=80=9D character. 




Kind regards

Stuart Tremain

Pharoah Lane = Software

AUSTRALIA

webdna@idfk.com.au





On 21 Mar 2017, at = 13:42, <brian@endeavotech.com> <brian@endeavotech.com> wrote:

I added the ; into my convertchars database. = Flushed=E2=80=A6 still having an issue.

I think I need a bigger list of escape = characters L

 
 
 

From: Stuart Tremain [mailto:webdna@idfk.com.au] 
Sent: Monday, March 20, 2017 9:45 PM
= To: WebDNA Talk List <talk@webdna.us>
Subject: Re: [WebDNA] Upload file to = mysql

 

That is a problem with a character causing MySQL to = fail.

 

Looking at your conversion db it looks like you have covered = everything except for ; (semicolon)

 

There may be something else as well.

 

Kind regards

 

Stuart Tremain

Pharoah Lane = Software

AUSTRALIA

webdna@idfk.com.au

 
 
 
 
 

On 21 Mar 2017, at 12:16, <brian@endeavotech.com> <brian@endeavotech.com> wrote:

 

ERROR TEXT: You have an error in your SQL syntax; = check the manual that corresponds to your MySQL server version for the = right syntax to use near ''\%PDF-1.5 \%=EF=BF=BD=EF=BF=BD=EF=BF=BD=EF=BF=BD=  1 0 obj <

 
 

When I look in the errorlog.txt file, the =EF=BF=BD = characters are the following symbols.

=C3=A2=C3=A3=C3=8F=C3=93

 
 

From: Stuart Tremain [mailto:webdna@idfk.com.au] 
Sent: Monday, March 20, 2017 9:03 PM
= To: WebDNA Talk List <talk@webdna.us>
Subject: Re: [WebDNA] Upload file to = mysql

 

What is the error ?

 

Kind regards

 

Stuart Tremain

Pharoah Lane = Software

AUSTRALIA

webdna@idfk.com.au

 
 
 
 
 

On 21 Mar 2017, at 12:00, Brian Boegershausen <brian@endeavotech.com> wrote:

 

Mysql error.

 

Brian Boegershausen

 

 


On Mon, Mar 20, 2017 at 8:59 PM -0400, "Stuart = Tremain" <webdna@idfk.com.au> wrote:

Brian, when you say it chokes, do = you mean that WebDNA stalls or do you get a MySQL error message = ?

 
 

Kind regards

 

Stuart Tremain

Pharoah Lane = Software

AUSTRALIA

webdna@idfk.com.au

 
 
 
 
 

On 21 Mar 2017, at 11:15, <brian@endeavotech.com> <brian@endeavotech.com> wrote:

 

Hi Stewart,

I have my content = field set to MEDIUMBLOB which allows for 16mb max files.

So far, I am using files around 100kb, so I am not = reaching the max yet.

 

My query writes all the data fields and uploads .txt files, = but once I change to a file like a PDF, it chokes.

 

[showif [referer]^file_manager.dna]

[FormVariables]

[showif = [name]^filename]

          &nb= sp;     [text show=3DF]TheFileNM=3D[Middle = StartAfter=3Dfilename=3D"&EndBefore=3D"][name][/middle][/text]

[/showif]

[showif = [name]^CPK]

          &nb= sp;     [text show=3DF]CPK=3D[value][/text]

[/showif]

[showif = [name]^JPK]

          &nb= sp;     [text show=3DF]JPK=3D[value][/text]

[/showif]

[/FormVariables]

 

[hideif [TheFileNM]=3D]

[hideif = [CPK]=3D]

[hideif [JPK]=3D]

[FormVariables]

[showif = [name]^"thefile"]

[SQLExecute = conn_ref=3DTheBlueBiller&result_var=3DUPLOAD_INS]

INSERT INTO UPLOAD

(FILE_ID, = COMPANY_ID, CLIENT_ID, JOB_ID, NAME, CONTENT, ROW_ADDED_DTTM)

VALUES ('', '[LOGIN_COMPANY_ID]', '[CPK]', '[JPK]', = '[TheFileNM]', '[convertchars = db=3Ddatabases/upload.db][value][/convertchars]', '[date %Y-%m-%d = %H:%M:%S]')

[/SQLExecute]

[/showif]

[/FormVariables]

[/hideif]

[/hideif]

[/hideif]

 

[!]=3D=3D=3D=3D=3D=3D=3D=3DUPLOAD.DB = FILE------------[/!]

FROM   = TO

'          &n= bsp;    \'

"          &n= bsp;   \"

\          &n= bsp;   \\

%          &n= bsp; \%

 

From: Stuart Tremain [mailto:webdna@idfk.com.au] 
Sent: Monday, March 20, 2017 6:43 PM
= To: WebDNA Talk List <talk@webdna.us>
Subject: Re: [WebDNA] Upload file to = mysql

 

Hi Brian

 

I have not done that, but providing your MySQL field is = LONGBLOB all should work. 

 

Also to be able to insert images that are bigger than 1MB you = have to increase the max_allowed_packed option in the server = configuration file.

 

I use Navicat to write all my queries and then copy & = paset the query into my WebDNA doc. Navicat makes writing & = debugging fast.

 

Kind regards

 

Stuart Tremain

Pharoah Lane = Software

AUSTRALIA

webdna@idfk.com.au

 
 
 
 
 

On 21 Mar 2017, at 07:55, Brian = Boegershausen <brian@endeavotech.com> wrote:

 

Anyone successfully upload a file to a mysql db?
I can upload a text file but that is it.
Jpg and gif fail.

Unbuntu 14
Webdna 8.2
Mysql 5.5

 

Brian Boegershausen

 
 

--------------------------------------------------------- = This message is sent to you because you are subscribed to the mailing = list . To unsubscribe, E-mail to: archives: http://mail.webdna.us/list/talk@webdna.us Bug = Reporting: support@webdna.us


 

 

Virus-free. 
www.avg.com

--------------------------------------------------------- = This message is sent to you because you are subscribed to the mailing = list . To unsubscribe, E-mail to: archives: http://mail.webdna.us/list/talk@webdna.us Bug = Reporting: support@webdna.us

--------------------------------------------------------- = This message is sent to you because you are subscribed to the mailing = list . To unsubscribe, E-mail to: archives: http://mail.webdna.us/list/talk@webdna.us Bug = Reporting: support@webdna.us


 

--------------------------------------------------------- = This message is sent to you because you are subscribed to the mailing = list . To unsubscribe, E-mail to: archives: http://mail.webdna.us/list/talk@webdna.us Bug = Reporting: support@webdna.us


--------------------------------------------------------- This message = is sent to you because you are subscribed to the mailing list . To = unsubscribe, E-mail to: archives: http://mail.webdna.us/list/talk@webdna.us Bug = Reporting: support@webdna.us


 

 

Virus-free. 

www.avg.com

--------------------------------------------------------- = This message is sent to you because you are subscribed to the mailing = list . To unsubscribe, E-mail to: archives: http://mail.webdna.us/list/talk@webdna.us Bug = Reporting: support@webdna.us

--------------------------------------------------------- = This message is sent to you because you are subscribed to the mailing = list . To unsubscribe, E-mail to: archives: http://mail.webdna.us/list/talk@webdna.us Bug = Reporting: support@webdna.us


 

 

Virus-free. 
www.avg.com

--------------------------------------------------------- = This message is sent to you because you are subscribed to the mailing = list . To unsubscribe, E-mail to: archives: http://mail.webdna.us/list/talk@webdna.us Bug = Reporting: support@webdna.us

--------------------------------------------------------- = This message is sent to you because you are subscribed to the mailing = list . To unsubscribe, E-mail to: archives: http://mail.webdna.us/list/talk@webdna.us Bug = Reporting: support@webdna.us


--------------------------------------------------------- = This message is sent to you because you are subscribed to the mailing = list . To unsubscribe, E-mail to: archives: http://mail.webdna.us/list/talk@webdna.us Bug Reporting: = support@webdna.us = --------------------------------------------------------- This message = is sent to you because you are subscribed to the mailing list . To = unsubscribe, E-mail to: archives: http://mail.webdna.us/list/talk@webdna.us Bug Reporting: = support@webdna.us
--------------------------------------------------------- This message = is sent to you because you are subscribed to the mailing list . To = unsubscribe, E-mail to: archives: http://mail.webdna.us/list/talk@webdna.us Bug Reporting: = support@webdna.us

--------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: archives: http://mail.webdna.us/list/talk@webdna.us Bug Reporting: support@webdna.us

= --------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: archives: http://mail.webdna.us/list/talk@webdna.us Bug Reporting: support@webdna.us --Apple-Mail=_E1264B20-BF32-48DF-900C-E5B4C109559D-- . Associated Messages, from the most recent to the oldest:

    
  1. Re: [WebDNA] Upload file to mysql (Brian Boegershausen 2017)
  2. Re: [WebDNA] Upload file to mysql (Stuart Tremain 2017)
  3. Re: [WebDNA] Upload file to mysql (Brian Boegershausen 2017)
  4. Re: [WebDNA] Upload file to mysql (Stuart Tremain 2017)
  5. Re: [WebDNA] Upload file to mysql (Stuart Tremain 2017)
  6. Re: [WebDNA] Upload file to mysql (Brian Boegershausen 2017)
  7. Re: [WebDNA] Upload file to mysql (Stuart Tremain 2017)
  8. RE: [WebDNA] Upload file to mysql ( 2017)
  9. Re: [WebDNA] Upload file to mysql (Stuart Tremain 2017)
  10. RE: [WebDNA] Upload file to mysql ( 2017)
  11. Re: [WebDNA] Upload file to mysql (Stuart Tremain 2017)
  12. Re: [WebDNA] Upload file to mysql (Brian Boegershausen 2017)
  13. Re: [WebDNA] Upload file to mysql (Stuart Tremain 2017)
  14. RE: [WebDNA] Upload file to mysql ( 2017)
  15. [BULK] Re: [WebDNA] Upload file to mysql ("WJ Starck, DDS" 2017)
  16. Re: [WebDNA] Upload file to mysql (Stuart Tremain 2017)
  17. [WebDNA] Upload file to mysql (Brian Boegershausen 2017)
1083 --Apple-Mail=_E1264B20-BF32-48DF-900C-E5B4C109559D Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset=utf-8 Yes, PHP has a nice escape routine. I should write one for WebDNA as I would use it, at the moment I just = use GREP for a few characters. Kind regards Stuart Tremain Pharoah Lane Software AUSTRALIA webdna@idfk.com.au > On 22 Mar 2017, at 00:17, Brian Boegershausen = wrote: >=20 > Thank stuart. > After a few more painful hours of tinkering, i decided to write the = upload/download pages in php.=20 > Works great now. All the escape context is built right in. > Not my favorite option, but why reinvent the wheel. >=20 >=20 > Brian Boegershausen >=20 >=20 >=20 > From: Stuart Tremain > Sent: Monday, March 20, 10:58 PM > Subject: Re: [WebDNA] Upload file to mysql > To: WebDNA Talk List >=20 > http://php.net/manual/en/mysqli.real-escape-string.php = > Characters encoded are NUL (ASCII 0), \n, \r, \, ', ", and Control-Z. >=20 >=20 > Kind regards >=20 > Stuart Tremain >=20 > Pharoah Lane Software >=20 > AUSTRALIA >=20 > webdna@idfk.com.au >=20 >=20 >=20 >=20 >=20 >> On 21 Mar 2017, at 13:51, Brian Boegershausen > wrote: >>=20 >> You think i should [url]ize the string? >> Then i can look for %0A and things like that. >>=20 >> Brian Boegershausen >>=20 >>=20 >>=20 >>=20 >>=20 >> On Mon, Mar 20, 2017 at 10:49 PM -0400, "Stuart Tremain" = > wrote: >=20 > I think that is where your problem lies. >=20 > https://dev.mysql.com/doc/refman/5.7/en/string-literals.html = > The MySQL manual page for strings says: >=20 > \0 An ASCII NUL (0x00) character. >=20 > \' A single quote (=E2=80=9C'=E2=80=9D) character. >=20 > \" A double quote (=E2=80=9C"=E2=80=9D) character. >=20 > \b A backspace character. >=20 > \n A newline (linefeed) character. >=20 > \r A carriage return character. >=20 > \t A tab character. >=20 > \Z ASCII 26 (Control-Z).=20 >=20 > \\ A backslash (=E2=80=9C\=E2=80=9D) character. >=20 > \% A =E2=80=9C%=E2=80=9D character.=20 >=20 > \_ A =E2=80=9C_=E2=80=9D character.=20 >=20 >=20 >=20 >=20 >=20 > Kind regards >=20 > Stuart Tremain >=20 > Pharoah Lane Software >=20 > AUSTRALIA >=20 > webdna@idfk.com.au >=20 >=20 >=20 >=20 >=20 >> On 21 Mar 2017, at 13:42, > > wrote: >>=20 >> I added the ; into my convertchars database. Flushed=E2=80=A6 still = having an issue. >>=20 >> I think I need a bigger list of escape characters L >>=20 >> =20 >> =20 >> =20 >> From: Stuart Tremain [mailto:webdna@idfk.com.au = ]=20 >> Sent: Monday, March 20, 2017 9:45 PM >> To: WebDNA Talk List > >> Subject: Re: [WebDNA] Upload file to mysql >>=20 >> =20 >> That is a problem with a character causing MySQL to fail. >>=20 >> =20 >> Looking at your conversion db it looks like you have covered = everything except for ; (semicolon) >>=20 >> =20 >> There may be something else as well. >>=20 >> =20 >> Kind regards >>=20 >> =20 >> Stuart Tremain >>=20 >> Pharoah Lane Software >>=20 >> AUSTRALIA >>=20 >> webdna@idfk.com.au >> =20 >> =20 >> =20 >> =20 >> =20 >>> On 21 Mar 2017, at 12:16, > > wrote: >>>=20 >>> =20 >>> ERROR TEXT: You have an error in your SQL syntax; check the manual = that corresponds to your MySQL server version for the right syntax to = use near ''\%PDF-1.5 \%=EF=BF=BD=EF=BF=BD=EF=BF=BD=EF=BF=BD 1 0 obj < >>>=20 >>> =20 >>> =20 >>> When I look in the errorlog.txt file, the =EF=BF=BD characters are = the following symbols. >>>=20 >>> =C3=A2=C3=A3=C3=8F=C3=93 >>>=20 >>> =20 >>> =20 >>> From: Stuart Tremain [mailto:webdna@idfk.com.au = ]=20 >>> Sent: Monday, March 20, 2017 9:03 PM >>> To: WebDNA Talk List > >>> Subject: Re: [WebDNA] Upload file to mysql >>>=20 >>> =20 >>> What is the error ? >>>=20 >>> =20 >>> Kind regards >>>=20 >>> =20 >>> Stuart Tremain >>>=20 >>> Pharoah Lane Software >>>=20 >>> AUSTRALIA >>>=20 >>> webdna@idfk.com.au >>> =20 >>> =20 >>> =20 >>> =20 >>> =20 >>>> On 21 Mar 2017, at 12:00, Brian Boegershausen = > wrote: >>>>=20 >>>> =20 >>>> Mysql error. >>>>=20 >>>> =20 >>>> Brian Boegershausen >>>>=20 >>>> =20 >>>> =20 >>>>=20 >>>>=20 >>>>=20 >>>> On Mon, Mar 20, 2017 at 8:59 PM -0400, "Stuart Tremain" = > wrote: >>>>=20 >>>>> Brian, when you say it chokes, do you mean that WebDNA stalls or = do you get a MySQL error message ? >>>>>=20 >>>>> =20 >>>>> =20 >>>>> Kind regards >>>>>=20 >>>>> =20 >>>>> Stuart Tremain >>>>>=20 >>>>> Pharoah Lane Software >>>>>=20 >>>>> AUSTRALIA >>>>>=20 >>>>> webdna@idfk.com.au >>>>> =20 >>>>> =20 >>>>> =20 >>>>> =20 >>>>> =20 >>>>>> On 21 Mar 2017, at 11:15, > > wrote: >>>>>>=20 >>>>>> =20 >>>>>> Hi Stewart, >>>>>>=20 >>>>>> I have my content field set to MEDIUMBLOB which allows for 16mb = max files. >>>>>>=20 >>>>>> So far, I am using files around 100kb, so I am not reaching the = max yet. >>>>>>=20 >>>>>> =20 >>>>>> My query writes all the data fields and uploads .txt files, but = once I change to a file like a PDF, it chokes. >>>>>>=20 >>>>>> =20 >>>>>> [showif [referer]^file_manager.dna] >>>>>>=20 >>>>>> [formvariables] >>>>>>=20 >>>>>> [showif [name]^filename] >>>>>>=20 >>>>>> [text show=3DF]TheFileNM=3D[Middle = StartAfter=3Dfilename=3D"&EndBefore=3D"][name][/middle][/text] >>>>>>=20 >>>>>> [/showif] >>>>>>=20 >>>>>> [showif [name]^CPK] >>>>>>=20 >>>>>> [text show=3DF]CPK=3D[value][/text] >>>>>>=20 >>>>>> [/showif] >>>>>>=20 >>>>>> [showif [name]^JPK] >>>>>>=20 >>>>>> [text show=3DF]JPK=3D[value][/text] >>>>>>=20 >>>>>> [/showif] >>>>>>=20 >>>>>> [/FormVariables] >>>>>>=20 >>>>>> =20 >>>>>> [hideif [TheFileNM]=3D] >>>>>>=20 >>>>>> [hideif [CPK]=3D] >>>>>>=20 >>>>>> [hideif [JPK]=3D] >>>>>>=20 >>>>>> [formvariables] >>>>>>=20 >>>>>> [showif [name]^"thefile"] >>>>>>=20 >>>>>> [SQLExecute conn_ref=3DTheBlueBiller&result_var=3DUPLOAD_INS] >>>>>>=20 >>>>>> INSERT INTO UPLOAD >>>>>>=20 >>>>>> (FILE_ID, COMPANY_ID, CLIENT_ID, JOB_ID, NAME, CONTENT, = ROW_ADDED_DTTM) >>>>>>=20 >>>>>> VALUES ('', '[LOGIN_COMPANY_ID]', '[CPK]', '[JPK]', = '[TheFileNM]', '[convertchars = db=3Ddatabases/upload.db][value][/convertchars]', '[date %Y-%m-%d = %H:%M:%S]') >>>>>>=20 >>>>>> [/SQLExecute] >>>>>>=20 >>>>>> [/showif] >>>>>>=20 >>>>>> [/FormVariables] >>>>>>=20 >>>>>> [/hideif] >>>>>>=20 >>>>>> [/hideif] >>>>>>=20 >>>>>> [/hideif] >>>>>>=20 >>>>>> =20 >>>>>> [!]=3D=3D=3D=3D=3D=3D=3D=3DUPLOAD.DB FILE------------[/!] >>>>>>=20 >>>>>> FROM TO >>>>>>=20 >>>>>> ' \' >>>>>>=20 >>>>>> " \" >>>>>>=20 >>>>>> \ \\ >>>>>>=20 >>>>>> % \% >>>>>>=20 >>>>>> =20 >>>>>> From: Stuart Tremain [mailto:webdna@idfk.com.au = ]=20 >>>>>> Sent: Monday, March 20, 2017 6:43 PM >>>>>> To: WebDNA Talk List > >>>>>> Subject: Re: [WebDNA] Upload file to mysql >>>>>>=20 >>>>>> =20 >>>>>> Hi Brian >>>>>>=20 >>>>>> =20 >>>>>> I have not done that, but providing your MySQL field is LONGBLOB = all should work.=20 >>>>>>=20 >>>>>> =20 >>>>>> Also to be able to insert images that are bigger than 1MB you = have to increase the max_allowed_packed option in the server = configuration file. >>>>>>=20 >>>>>> =20 >>>>>> I use Navicat to write all my queries and then copy & paset the = query into my WebDNA doc. Navicat makes writing & debugging fast. >>>>>>=20 >>>>>> =20 >>>>>> Kind regards >>>>>>=20 >>>>>> =20 >>>>>> Stuart Tremain >>>>>>=20 >>>>>> Pharoah Lane Software >>>>>>=20 >>>>>> AUSTRALIA >>>>>>=20 >>>>>> webdna@idfk.com.au >>>>>> =20 >>>>>> =20 >>>>>> =20 >>>>>> =20 >>>>>> =20 >>>>>>> On 21 Mar 2017, at 07:55, Brian Boegershausen = > wrote: >>>>>>>=20 >>>>>>> =20 >>>>>>> Anyone successfully upload a file to a mysql db? >>>>>>> I can upload a text file but that is it. >>>>>>> Jpg and gif fail. >>>>>>>=20 >>>>>>> Unbuntu 14 >>>>>>> Webdna 8.2 >>>>>>> Mysql 5.5 >>>>>>>=20 >>>>>>> =20 >>>>>>> Brian Boegershausen >>>>>>>=20 >>>>>>> =20 >>>>>>> =20 >>>>>>> --------------------------------------------------------- This = message is sent to you because you are subscribed to the mailing list . = To unsubscribe, E-mail to: archives: = http://mail.webdna.us/list/talk@webdna.us = Bug Reporting: = support@webdna.us >>>>>>=20 >>>>>> =20 >>>>>>=20 >>>>>> =20 >>>>>> Virus-free.=20 >>>>>> www.avg.com = >>>>>> --------------------------------------------------------- This = message is sent to you because you are subscribed to the mailing list . = To unsubscribe, E-mail to: archives: = http://mail.webdna.us/list/talk@webdna.us = Bug Reporting: = support@webdna.us >>>>>> --------------------------------------------------------- This = message is sent to you because you are subscribed to the mailing list . = To unsubscribe, E-mail to: archives: = http://mail.webdna.us/list/talk@webdna.us = Bug Reporting: = support@webdna.us >>>>>=20 >>>>> =20 >>>>>=20 >>>>> --------------------------------------------------------- This = message is sent to you because you are subscribed to the mailing list . = To unsubscribe, E-mail to: archives: = http://mail.webdna.us/list/talk@webdna.us = Bug Reporting: = support@webdna.us >>>>=20 >>>> --------------------------------------------------------- This = message is sent to you because you are subscribed to the mailing list . = To unsubscribe, E-mail to: archives: = http://mail.webdna.us/list/talk@webdna.us = Bug Reporting: = support@webdna.us >>>=20 >>> =20 >>>=20 >>> =20 >>> Virus-free.=20 >>> www.avg.com = >>> --------------------------------------------------------- This = message is sent to you because you are subscribed to the mailing list . = To unsubscribe, E-mail to: archives: = http://mail.webdna.us/list/talk@webdna.us = Bug Reporting: = support@webdna.us >>> --------------------------------------------------------- This = message is sent to you because you are subscribed to the mailing list . = To unsubscribe, E-mail to: archives: = http://mail.webdna.us/list/talk@webdna.us = Bug Reporting: = support@webdna.us >>=20 >> =20 >>=20 >> =20 >> Virus-free.=20 >> = >> www.avg.com >>=20 >> --------------------------------------------------------- This = message is sent to you because you are subscribed to the mailing list . = To unsubscribe, E-mail to: archives: = http://mail.webdna.us/list/talk@webdna.us = Bug Reporting: = support@webdna.us >> --------------------------------------------------------- This = message is sent to you because you are subscribed to the mailing list . = To unsubscribe, E-mail to: archives: = http://mail.webdna.us/list/talk@webdna.us = Bug Reporting: = support@webdna.us >=20 > --------------------------------------------------------- This message = is sent to you because you are subscribed to the mailing list . To = unsubscribe, E-mail to: archives: = http://mail.webdna.us/list/talk@webdna.us = Bug Reporting: = support@webdna.us = --------------------------------------------------------- This message = is sent to you because you are subscribed to the mailing list . To = unsubscribe, E-mail to: archives: = http://mail.webdna.us/list/talk@webdna.us = Bug Reporting: = support@webdna.us > --------------------------------------------------------- This message = is sent to you because you are subscribed to the mailing list . To = unsubscribe, E-mail to: archives: = http://mail.webdna.us/list/talk@webdna.us Bug Reporting: = support@webdna.us >=20 > --------------------------------------------------------- This message = is sent to you because you are subscribed to the mailing list . To = unsubscribe, E-mail to: archives: = http://mail.webdna.us/list/talk@webdna.us Bug Reporting: = support@webdna.us --Apple-Mail=_E1264B20-BF32-48DF-900C-E5B4C109559D Content-Transfer-Encoding: quoted-printable Content-Type: text/html; charset=utf-8 Yes, PHP has a nice escape routine.

I should write one for WebDNA as I = would use it, at the moment I just use GREP for a few = characters.

Kind regards

Stuart Tremain
Pharoah Lane Software
AUSTRALIA






On 22 Mar 2017, at 00:17, Brian Boegershausen <brian@endeavotech.com> wrote:

Thank stuart.
After a few more painful hours of tinkering, i decided to write the = upload/download pages in php.
Works great now. All the escape context is built right in.
Not my favorite option, but why reinvent the wheel.


Brian Boegershausen



From: Stuart Tremain
Sent: Monday, March 20, 10:58 PM
Subject: Re: [WebDNA] Upload file to mysql
To: WebDNA Talk List

http://php.net/manual/en/mysqli.real-escape-string.php

Characters encoded are NUL (ASCII 0), \n, \r, \, ', ", and Control-Z.

Kind regards

Stuart Tremain

Pharoah Lane Software

AUSTRALIA

webdna@idfk.com.au





On 21 Mar 2017, at = 13:51, Brian Boegershausen <brian@endeavotech.com> wrote:

You think i should [url]ize the string?
Then i can look for %0A and things like that.

Brian Boegershausen




On Mon, Mar 20, 2017 at 10:49 PM -0400, "Stuart Tremain" = <webdna@idfk.com.au> wrote:


I think that is where your problem lies.

https://dev.mysql.com/doc/refman/5.7/en/string-literals.html

The MySQL manual = page for strings says:

\0   An ASCII NUL (0x00) character.

\'   A single quote (=E2=80=9C'=E2=80=9D) = character.

\"   A double quote (=E2=80=9C"=E2= =80=9D) character.

\b   A = backspace character.

\n   A = newline (linefeed) character.

\r   A = carriage return character.

\t   A tab = character.

\Z   ASCII 26 = (Control-Z). 

\\   A = backslash (=E2=80=9C\=E2=80=9D) character.

\%   A =E2=80=9C%=E2=80=9D character. 

\_   A =E2=80=9C_=E2=80=9D character. 




Kind regards

Stuart Tremain

Pharoah Lane = Software

AUSTRALIA

webdna@idfk.com.au





On 21 Mar 2017, at = 13:42, <brian@endeavotech.com> <brian@endeavotech.com> wrote:

I added the ; into my convertchars database. = Flushed=E2=80=A6 still having an issue.

I think I need a bigger list of escape = characters L

 
 
 

From: Stuart Tremain [mailto:webdna@idfk.com.au] 
Sent: Monday, March 20, 2017 9:45 PM
= To: WebDNA Talk List <talk@webdna.us>
Subject: Re: [WebDNA] Upload file to = mysql

 

That is a problem with a character causing MySQL to = fail.

 

Looking at your conversion db it looks like you have covered = everything except for ; (semicolon)

 

There may be something else as well.

 

Kind regards

 

Stuart Tremain

Pharoah Lane = Software

AUSTRALIA

webdna@idfk.com.au

 
 
 
 
 

On 21 Mar 2017, at 12:16, <brian@endeavotech.com> <brian@endeavotech.com> wrote:

 

ERROR TEXT: You have an error in your SQL syntax; = check the manual that corresponds to your MySQL server version for the = right syntax to use near ''\%PDF-1.5 \%=EF=BF=BD=EF=BF=BD=EF=BF=BD=EF=BF=BD=  1 0 obj <

 
 

When I look in the errorlog.txt file, the =EF=BF=BD = characters are the following symbols.

=C3=A2=C3=A3=C3=8F=C3=93

 
 

From: Stuart Tremain [mailto:webdna@idfk.com.au] 
Sent: Monday, March 20, 2017 9:03 PM
= To: WebDNA Talk List <talk@webdna.us>
Subject: Re: [WebDNA] Upload file to = mysql

 

What is the error ?

 

Kind regards

 

Stuart Tremain

Pharoah Lane = Software

AUSTRALIA

webdna@idfk.com.au

 
 
 
 
 

On 21 Mar 2017, at 12:00, Brian Boegershausen <brian@endeavotech.com> wrote:

 

Mysql error.

 

Brian Boegershausen

 

 


On Mon, Mar 20, 2017 at 8:59 PM -0400, "Stuart = Tremain" <webdna@idfk.com.au> wrote:

Brian, when you say it chokes, do = you mean that WebDNA stalls or do you get a MySQL error message = ?

 
 

Kind regards

 

Stuart Tremain

Pharoah Lane = Software

AUSTRALIA

webdna@idfk.com.au

 
 
 
 
 

On 21 Mar 2017, at 11:15, <brian@endeavotech.com> <brian@endeavotech.com> wrote:

 

Hi Stewart,

I have my content = field set to MEDIUMBLOB which allows for 16mb max files.

So far, I am using files around 100kb, so I am not = reaching the max yet.

 

My query writes all the data fields and uploads .txt files, = but once I change to a file like a PDF, it chokes.

 

[showif [referer]^file_manager.dna]

[formvariables]

[showif = [name]^filename]

          &nb= sp;     [text show=3DF]TheFileNM=3D[Middle = StartAfter=3Dfilename=3D"&EndBefore=3D"][name][/middle][/text]

[/showif]

[showif = [name]^CPK]

          &nb= sp;     [text show=3DF]CPK=3D[value][/text]

[/showif]

[showif = [name]^JPK]

          &nb= sp;     [text show=3DF]JPK=3D[value][/text]

[/showif]

[/FormVariables]

 

[hideif [TheFileNM]=3D]

[hideif = [CPK]=3D]

[hideif [JPK]=3D]

[formvariables]

[showif = [name]^"thefile"]

[SQLExecute = conn_ref=3DTheBlueBiller&result_var=3DUPLOAD_INS]

INSERT INTO UPLOAD

(FILE_ID, = COMPANY_ID, CLIENT_ID, JOB_ID, NAME, CONTENT, ROW_ADDED_DTTM)

VALUES ('', '[LOGIN_COMPANY_ID]', '[CPK]', '[JPK]', = '[TheFileNM]', '[convertchars = db=3Ddatabases/upload.db][value][/convertchars]', '[date %Y-%m-%d = %H:%M:%S]')

[/SQLExecute]

[/showif]

[/FormVariables]

[/hideif]

[/hideif]

[/hideif]

 

[!]=3D=3D=3D=3D=3D=3D=3D=3DUPLOAD.DB = FILE------------[/!]

FROM   = TO

'          &n= bsp;    \'

"          &n= bsp;   \"

\          &n= bsp;   \\

%          &n= bsp; \%

 

From: Stuart Tremain [mailto:webdna@idfk.com.au] 
Sent: Monday, March 20, 2017 6:43 PM
= To: WebDNA Talk List <talk@webdna.us>
Subject: Re: [WebDNA] Upload file to = mysql

 

Hi Brian

 

I have not done that, but providing your MySQL field is = LONGBLOB all should work. 

 

Also to be able to insert images that are bigger than 1MB you = have to increase the max_allowed_packed option in the server = configuration file.

 

I use Navicat to write all my queries and then copy & = paset the query into my WebDNA doc. Navicat makes writing & = debugging fast.

 

Kind regards

 

Stuart Tremain

Pharoah Lane = Software

AUSTRALIA

webdna@idfk.com.au

 
 
 
 
 

On 21 Mar 2017, at 07:55, Brian = Boegershausen <brian@endeavotech.com> wrote:

 

Anyone successfully upload a file to a mysql db?
I can upload a text file but that is it.
Jpg and gif fail.

Unbuntu 14
Webdna 8.2
Mysql 5.5

 

Brian Boegershausen

 
 

--------------------------------------------------------- = This message is sent to you because you are subscribed to the mailing = list . To unsubscribe, E-mail to: archives: http://mail.webdna.us/list/talk@webdna.us Bug = Reporting: support@webdna.us


 

 

Virus-free. 
www.avg.com

--------------------------------------------------------- = This message is sent to you because you are subscribed to the mailing = list . To unsubscribe, E-mail to: archives: http://mail.webdna.us/list/talk@webdna.us Bug = Reporting: support@webdna.us

--------------------------------------------------------- = This message is sent to you because you are subscribed to the mailing = list . To unsubscribe, E-mail to: archives: http://mail.webdna.us/list/talk@webdna.us Bug = Reporting: support@webdna.us


 

--------------------------------------------------------- = This message is sent to you because you are subscribed to the mailing = list . To unsubscribe, E-mail to: archives: http://mail.webdna.us/list/talk@webdna.us Bug = Reporting: support@webdna.us


--------------------------------------------------------- This message = is sent to you because you are subscribed to the mailing list . To = unsubscribe, E-mail to: archives: http://mail.webdna.us/list/talk@webdna.us Bug = Reporting: support@webdna.us


 

 

Virus-free. 

www.avg.com

--------------------------------------------------------- = This message is sent to you because you are subscribed to the mailing = list . To unsubscribe, E-mail to: archives: http://mail.webdna.us/list/talk@webdna.us Bug = Reporting: support@webdna.us

--------------------------------------------------------- = This message is sent to you because you are subscribed to the mailing = list . To unsubscribe, E-mail to: archives: http://mail.webdna.us/list/talk@webdna.us Bug = Reporting: support@webdna.us


 

 

Virus-free. 
www.avg.com

--------------------------------------------------------- = This message is sent to you because you are subscribed to the mailing = list . To unsubscribe, E-mail to: archives: http://mail.webdna.us/list/talk@webdna.us Bug = Reporting: support@webdna.us

--------------------------------------------------------- = This message is sent to you because you are subscribed to the mailing = list . To unsubscribe, E-mail to: archives: http://mail.webdna.us/list/talk@webdna.us Bug = Reporting: support@webdna.us


--------------------------------------------------------- = This message is sent to you because you are subscribed to the mailing = list . To unsubscribe, E-mail to: archives: http://mail.webdna.us/list/talk@webdna.us Bug Reporting: = support@webdna.us = --------------------------------------------------------- This message = is sent to you because you are subscribed to the mailing list . To = unsubscribe, E-mail to: archives: http://mail.webdna.us/list/talk@webdna.us Bug Reporting: = support@webdna.us
--------------------------------------------------------- This message = is sent to you because you are subscribed to the mailing list . To = unsubscribe, E-mail to: archives: http://mail.webdna.us/list/talk@webdna.us Bug Reporting: = support@webdna.us

--------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: archives: http://mail.webdna.us/list/talk@webdna.us Bug Reporting: support@webdna.us

= --------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: archives: http://mail.webdna.us/list/talk@webdna.us Bug Reporting: support@webdna.us --Apple-Mail=_E1264B20-BF32-48DF-900C-E5B4C109559D-- . Stuart Tremain

DOWNLOAD WEBDNA NOW!

Top Articles:

Talk List

The WebDNA community talk-list is the best place to get some help: several hundred extremely proficient programmers with an excellent knowledge of WebDNA and an excellent spirit will deliver all the tips and tricks you can imagine...

Related Readings:

[OT] Might be of interest... (2006) Does [Sendmail] create html? (2002) newbie question about zip code search (2003) Multiple FlushDatabases (2000) [WebDNA] a major shift in strategy? (2008) How can I record purchases to a database? (1998) WebSTAR 2.1 freezes my Mac (1997) Repeating Fields (1997) [WebDNA] Upper ASCII and charset [OT] (2016) Timeout question .. (2003) [HIDEIF] inside [FOUNDITEM] (1997) problems with 2 tags (1997) Email template names (1997) WebCatalog 2.0 & WebDNA docs in HTML ... (1997) Can this be done? (1997) Applescript error (1998) Submitting ampersands in forms... (1998) [SearchString] (1998) case sensitivity in lookups (1997) Locking up with WebCatalog... (1997)