2017



=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 cont=ent 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]^filenam=e]

&n=bsp;            =;   [text show=3DF]TheFileNM=3D[Middle StartAfter=3Dfilename=3D"&=amp;EndBefore=3D"][name][/middle][/text]

=

[/showif]<=/div>

[showif [name]^CPK]

   &=nbsp;            [te=xt show=3DF]CPK=3D[value][/text]

[/showif]

[showif [name]^JPK]<=/span>

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

[/showif]

[/FormVariables]

 

[hideif [TheFileNM]=3D]

[hideif =[CPK]=3D]

[hideif [JPK]=3D]

[FormVariables]

[showif [name]^"thefile"]

[SQLExe=cute conn_ref=3DTheBlueBiller&result_var=3DUPLOAD_INS]<=/o:p>

INSERT INTO UPLOA=D

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

VAL=UES ('', '[LOGIN_COMPANY_ID]', '[CPK]', '[JPK]', '[TheFileNM]', '[convertch=ars 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

'  =             \'=

"&nb=sp;            = \"

\=            &nb=sp; \\

<=span style=3D"font-size: 11pt; font-family: Calibri, sans-serif;" class=3D"=">%            \%

 

From:&nb=sp;Stuart Tremain [mailto:webdna@idfk.com=..au] 
<=b class=3D"">Sent: Mo=nday, 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 & debug=ging fast.

 

Kind regards

 

Stu=art Tremain

Pharoah Lane Software=

AUSTRALIA<=/span>

webdna@idfk.com.au

 

 

 

=

 

<=/div>

 

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

 

Anyon=e successfully upload a file to a mysql db?
I can upload a te=xt file but that is it.
Jpg and gif fail.

Unbuntu 14
Webdna 8.2
Mysql 5.5

<=o:p class=3D""> 

Brian Boegershausen

 <=/div>

 =;

-----------------------=---------------------------------- 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 messag=e is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: <=/span>archives: http://m=ail.webdna.us/list/talk@webdna.us= Bug Reporting: support@webdna.us
---------------------------------------------------------This message is sent to you because you are subscribed tothe mailing list .To unsubscribe, E-mail to: archives: http://mail.webdna.us/list/talk@webdna.usBug Reporting: support@webdna.us---------------------------------------------------------This message is sent to you because you are subscribed tothe mailing list .To unsubscribe, E-mail to: archives: http://mail.webdna.us/list/talk@webdna.usBug Reporting: support@webdna.us------=_Part_8736_2096046184.1490058024203--. Associated Messages, from the most recent to the oldest:

=	Virus-free. www.=avg.com

Re: [WebDNA] Upload file to mysql (Brian Boegershausen 2017) Re: [WebDNA] Upload file to mysql (Stuart Tremain 2017) Re: [WebDNA] Upload file to mysql (Brian Boegershausen 2017) Re: [WebDNA] Upload file to mysql (Stuart Tremain 2017) Re: [WebDNA] Upload file to mysql (Stuart Tremain 2017) Re: [WebDNA] Upload file to mysql (Brian Boegershausen 2017) Re: [WebDNA] Upload file to mysql (Stuart Tremain 2017) RE: [WebDNA] Upload file to mysql ( 2017) Re: [WebDNA] Upload file to mysql (Stuart Tremain 2017) RE: [WebDNA] Upload file to mysql ( 2017) Re: [WebDNA] Upload file to mysql (Stuart Tremain 2017) Re: [WebDNA] Upload file to mysql (Brian Boegershausen 2017) Re: [WebDNA] Upload file to mysql (Stuart Tremain 2017) RE: [WebDNA] Upload file to mysql ( 2017) [BULK] Re: [WebDNA] Upload file to mysql ("WJ Starck, DDS" 2017) Re: [WebDNA] Upload file to mysql (Stuart Tremain 2017) [WebDNA] Upload file to mysql (Brian Boegershausen 2017)

1073------=_Part_8736_2096046184.1490058024203Content-Type: text/plain; charset=UTF-8Content-Transfer-Encoding: quoted-printableMysql error.Brian BoegershausenOn Mon, Mar 20, 2017 at 8:59 PM -0400, "Stuart Tremain" wrote:Brian, when you say it chokes, do you mean that WebDNA stalls or do you get= a MySQL error message ?Kind regardsStuart TremainPharoah Lane SoftwareAUSTRALIAwebdna@idfk.com.auOn 21 Mar 2017, at 11:15, w=rote: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 m=ax yet.=C2=A0My query writes all the data fields and uploads .txt files, bu=t once I change to a file like a PDF, it chokes.=C2=A0[showif [referer]^fil=e_manager.dna][formvariables][showif [name]^filename]=C2=A0=C2=A0=C2=A0=C2==A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 [text= show=3DF]TheFileNM=3D[Middle StartAfter=3Dfilename=3D"&EndBefore=3D"][name=][/middle][/text][/showif][showif [name]^CPK]=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0==C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 [text show=3DF=]CPK=3D[value][/text][/showif][showif [name]^JPK]=C2=A0=C2=A0=C2=A0=C2=A0==C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 [text sh=ow=3DF]JPK=3D[value][/text][/showif][/FormVariables]=C2=A0[hideif [TheFileN=M]=3D][hideif [CPK]=3D][hideif [JPK]=3D][formvariables][showif [name]^"thef=ile"][SQLExecute conn_ref=3DTheBlueBiller&result_var=3DUPLOAD_INS]INSERT IN=TO UPLOAD(FILE_ID, COMPANY_ID, CLIENT_ID, JOB_ID, NAME, CONTENT, ROW_ADDED_=DTTM)VALUES ('', '[LOGIN_COMPANY_ID]', '[CPK]', '[JPK]', '[TheFileNM]', '[c=onvertchars db=3Ddatabases/upload.db][value][/convertchars]', '[date %Y-%m-=%d %H:%M:%S]')[/SQLExecute][/showif][/FormVariables][/hideif][/hideif][/hid=eif]=C2=A0[!]=3D=3D=3D=3D=3D=3D=3D=3DUPLOAD.DB FILE------------[/!]FROM=C2==A0=C2=A0 TO'=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0==C2=A0=C2=A0=C2=A0=C2=A0 \'"=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2==A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 \"\=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0==C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 \\%=C2=A0=C2=A0=C2=A0=C2=A0=C2==A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 \%=C2=A0From:=C2=A0Stuart Tremain [=mailto:webdna@idfk.com.au]=C2=A0Sent:=C2=A0Monday, March 20, 2017 6:43 PMTo:=C2=A0WebDNA Talk List Subject:=C2=A0Re: [WebDNA] Upload file to mysql=C2=A0Hi Brian=C2=A0I have n=ot done that, but providing your MySQL field is LONGBLOB all should work.==C2=A0=C2=A0Also to be able to insert images that are bigger than 1MB you h=ave to increase the max_allowed_packed option in the server configuration f=ile.=C2=A0I use Navicat to write all my queries and then copy & paset the q=uery into my WebDNA doc. Navicat makes writing & debugging fast.=C2=A0Kind =regards=C2=A0Stuart TremainPharoah Lane SoftwareAUSTRALIAwebdna@idfk.com.au==C2=A0=C2=A0=C2=A0=C2=A0=C2=A0On 21 Mar 2017, at 07:55, Brian Boegershausen wrote:=C2=A0Anyone successfully upload a file to a mysql db?I can upload a text file but that is it.Jpg and gif fail.Unbuntu 14Webdna 8.2Mysql 5.5=C2=A0Brian Boegershausen=C2=A0=C2=A0--------------------------------------------=------------- This message is sent to you because you are subscribed to the= mailing list . To unsubscribe, E-mail to: archives:=C2=A0http://mail.webdn=a.us/list/talk@webdna.us=C2=A0Bug Reporting:=C2=A0support@webdna.us=C2=A0==C2=A0Virus-free.=C2=A0www.avg.com-----------------------------------------=---------------- This message is sent to you because you are subscribed to =the mailing list . To unsubscribe, E-mail to: archives:=C2=A0http://mail.we=bdna.us/list/talk@webdna.us=C2=A0Bug Reporting:=C2=A0support@webdna.us-----=---------------------------------------------------- This message is sent t=o you because you are subscribed to the mailing list=C2=A0. To unsubscribe,= E-mail to:=C2=A0archives:=C2=A0http://mail.webdna.us/list/talk@webdna.us==C2=A0Bug Reporting:=C2=A0support@webdna.us---------------------------------------------------------This message is sent to you because you are subscribed tothe mailing list .To unsubscribe, E-mail to:=20archives: http://mail.webdna.us/list/talk@webdna.usBug Reporting: support@webdna.us------=_Part_8736_2096046184.1490058024203Content-Type: text/html; charset=utf-8Content-Transfer-Encoding: quoted-printable

Mysql error.



Brian Boegershausen









On Mon, Mar 20, 2017 at 8:59 PM -0400, "Stuart T=remain" <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 cont=ent 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]^filenam=e]

&n=bsp;            =;   [text show=3DF]TheFileNM=3D[Middle StartAfter=3Dfilename=3D"&=amp;EndBefore=3D"][name][/middle][/text]

=

[/showif]<=/div>

[showif [name]^CPK]

   &=nbsp;            [te=xt show=3DF]CPK=3D[value][/text]

[/showif]

[showif [name]^JPK]<=/span>

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

[/showif]

[/FormVariables]

 

[hideif [TheFileNM]=3D]

[hideif =[CPK]=3D]

[hideif [JPK]=3D]

[formvariables]

[showif [name]^"thefile"]

[SQLExe=cute conn_ref=3DTheBlueBiller&result_var=3DUPLOAD_INS]<=/o:p>

INSERT INTO UPLOA=D

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

VAL=UES ('', '[LOGIN_COMPANY_ID]', '[CPK]', '[JPK]', '[TheFileNM]', '[convertch=ars 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

'  =             \'=

"&nb=sp;            = \"

\=            &nb=sp; \\

<=span style=3D"font-size: 11pt; font-family: Calibri, sans-serif;" class=3D"=">%            \%

 

From:&nb=sp;Stuart Tremain [mailto:webdna@idfk.com=..au] 
<=b class=3D"">Sent: Mo=nday, 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 & debug=ging fast.

 

Kind regards

 

Stu=art Tremain

Pharoah Lane Software=

AUSTRALIA<=/span>

webdna@idfk.com.au

 

 

 

=

 

<=/div>

 

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

 

Anyon=e successfully upload a file to a mysql db?
I can upload a te=xt file but that is it.
Jpg and gif fail.

Unbuntu 14
Webdna 8.2
Mysql 5.5

<=o:p class=3D""> 

Brian Boegershausen

 <=/div>

 =;

-----------------------=---------------------------------- 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 messag=e is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: <=/span>archives: http://m=ail.webdna.us/list/talk@webdna.us= Bug Reporting: support@webdna.us
---------------------------------------------------------This message is sent to you because you are subscribed tothe mailing list .To unsubscribe, E-mail to: archives: http://mail.webdna.us/list/talk@webdna.usBug Reporting: support@webdna.us---------------------------------------------------------This message is sent to you because you are subscribed tothe mailing list .To unsubscribe, E-mail to: archives: http://mail.webdna.us/list/talk@webdna.usBug Reporting: support@webdna.us------=_Part_8736_2096046184.1490058024203--. Brian Boegershausen

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:

[shell] command seems flaky (2003) WebCat2b13MacPlugIn - more [date] problems (1997) SKU lookup (1997) [date format] w/in sendmail (1997) Summing fields (1997) Creating main- and sub-category search (1997) Problems with Price field (1997) Writing to PDF (2003) Online reference (1997) (OT) SERVER FREEZES ALL AT SAME TIME (2004) Re:multiple digests, please stop (1997) Color options - modified (1999) Need help with emailer- 2 issues (1997) Snake Bites (1997) WC2b15 File Corruption (1997) WebCatalog for LinuxPPC/SusePPC? (2000) Separate SSL Server (1997) flushdatabases (1997) shipcost (1997) 2nd Request for help/advice on variable pricing + MORE (2000)

=	Virus-free. www.=avg.com