File not uploaded with transient field & relationship

[tomhousley]

Hello,

I have two tables:

tbl_quote
tbl_quote_images

the structure of each is:

Code: Select all

quo_id       int(6)                                         (NULL)           NO      PRI     (NULL)   auto_increment  select,insert,update         
job_id       int(6)                                         (NULL)           YES             (NULL)                   select,insert,update         
quo_type     enum('Quote','Estimate','Risk Bearing Quote')  utf8_general_ci  YES             (NULL)                   select,insert,update         
quo_amount   decimal(10,2)                                  (NULL)           YES             (NULL)                   select,insert,update         
usr_id       int(6)                                         (NULL)           YES             (NULL)                   select,insert,update         
quo_deleted  tinyint(1)                                     (NULL)           YES             0                        select,insert,update         
quo_date     datetime                                       (NULL)           YES             (NULL)                   select,insert,update         


and

Code: Select all

qui_id              int(6)       (NULL)             NO      PRI     (NULL)   auto_increment  select,insert,update         
quo_id              int(6)       (NULL)             NO              (NULL)                   select,insert,update         
qui_image           longblob     (NULL)             YES             (NULL)                   select,insert,update         
qui_image_mimetype  varchar(64)  latin1_swedish_ci  YES             (NULL)                   select,insert,update         
qui_image_filename  varchar(64)  latin1_swedish_ci  YES             (NULL)                   select,insert,update         


/tbl_quote/fields.ini looks like this:

Code: Select all

__sql__ = "select * from tbl_quote where quo_deleted <>1 order by quo_id DESC"

[quo_id]
widget:label="Quote ID"

[job_id]
widget:label="Job ID"
widget:type = select
vocabulary = job_id

[quo_type]
widget:label="Quote Type"

[quo_amount]
widget:label="Amount"

[qui_id]
widget:label="Images Supplued By Client"
relationship=tbl_quote_images
transient=1
widget:type=grid
widget:columns="qui_image,qui_image_filename"

[usr_id]
widget:label="Entered By"

[quo_deleted]
widget:label="Delete Quote"
widget:type = checkbox
visibility:list = hidden


/tbl_quote/relationships.ini looks like this:

Code: Select all

[tbl_quote_images]
__sql__ = "SELECT * FROM tbl_quote_images WHERE quo_id='$quo_id'"
action:visible = 0


When I create a new record in tbl_quote and I choose multiple files (which are saved in tbl_quote_images) <150K each to upload and click on save, the images are not saved in the database, though the field qui_image shows just the filename.

Am I doing something incorrectly or is this a limitation of xataface?

Many thanks, Tom

[shannah]

Currently the file widget doesn't work inside the grid widget. I'm working on an ajax file upload widget that will be compatible with the grid widget but I don't have an ETA on its completion (it's currently in the pile of things to do).

You might be able to hack something together in the beforeSave() that will fetch the uploaded file and store it custom. E.g. use standard PHP file upload techniques... the file should show up in the $_FILES super global --- but you would have to get your hands a little dirty.

[tomhousley]

Hi Steve,

Thank you for the prompt reply. I think I will wait for the an ajax file upload widget.

Many thanks, Tom