Pepi Txispi
|
Posted: 12/09/2003, 2:15 PM |
|
HI guys, while using the Store example with CCS (trial version), I got this
error when the site is uploaded to an online server. BTW, La operación debe
usar una consulta actualizable, means something like "an updateable query
must be used" or "an updateable database must be used"
Source: Record add_to_cart / Insert Operation
Command Text: INSERT INTO store_shopping_cart_items(quantity, product_id,
shopping_cart_id) VALUES (1, 7, '2')
Error description: La operación debe usar una consulta actualizable.
(Microsoft JET Database Engine)<br>INSERT INTO
store_shopping_cart_items(quantity, product_id, shopping_cart_id) VALUES (1,
7, '2')<br><br>
However, it works perfectly with Microsoft IIS.
Looks like that some writing privileges are missing on the database file on
the remote server, right?
any hints?
Thanks
|
|
|
Pepi Txispi
|
Posted: 12/09/2003, 11:20 PM |
|
BTW you can see the web site for yourself at
www.mariosbm.net/irunorte2/default.asp
TRy to buy soemthing and you will see the error
This is gotta be it, because I think I am going to buy the proggie and have
full access to CCS support.
Thanks
"Pepi Txispi" <pepitxispi@telefonica.net> wrote in message
news:br5hhh$hrd$1@news.codecharge.com...
> HI guys, while using the Store example with CCS (trial version), I got
this
> error when the site is uploaded to an online server. BTW, La operación
debe
> usar una consulta actualizable, means something like "an updateable query
> must be used" or "an updateable database must be used"
> Source: Record add_to_cart / Insert Operation
> Command Text: INSERT INTO store_shopping_cart_items(quantity, product_id,
> shopping_cart_id) VALUES (1, 7, '2')
> Error description: La operación debe usar una consulta actualizable.
> (Microsoft JET Database Engine)<br>INSERT INTO
> store_shopping_cart_items(quantity, product_id, shopping_cart_id) VALUES
(1,
> 7, '2')<br><br>
>
> However, it works perfectly with Microsoft IIS.
>
> Looks like that some writing privileges are missing on the database file
on
> the remote server, right?
>
> any hints?
>
> Thanks
>
>
|
|
|
Pepi Txispi
|
Posted: 12/10/2003, 12:08 AM |
|
Got it...the online provider granted writing privileges to the ddbb and now
it works OK
Thanks
"Pepi Txispi" <pepitxispi@telefonica.net> wrote in message
news:br6hfq$nnk$1@news.codecharge.com...
> BTW you can see the web site for yourself at
> www.mariosbm.net/irunorte2/default.asp
>
> TRy to buy soemthing and you will see the error
>
> This is gotta be it, because I think I am going to buy the proggie and
have
> full access to CCS support.
>
> Thanks
> "Pepi Txispi" <pepitxispi@telefonica.net> wrote in message
>news:br5hhh$hrd$1@news.codecharge.com...
> > HI guys, while using the Store example with CCS (trial version), I got
> this
> > error when the site is uploaded to an online server. BTW, La operación
> debe
> > usar una consulta actualizable, means something like "an updateable
query
> > must be used" or "an updateable database must be used"
> > Source: Record add_to_cart / Insert Operation
> > Command Text: INSERT INTO store_shopping_cart_items(quantity,
product_id,
> > shopping_cart_id) VALUES (1, 7, '2')
> > Error description: La operación debe usar una consulta actualizable.
> > (Microsoft JET Database Engine)<br>INSERT INTO
> > store_shopping_cart_items(quantity, product_id, shopping_cart_id) VALUES
> (1,
> > 7, '2')<br><br>
> >
> > However, it works perfectly with Microsoft IIS.
> >
> > Looks like that some writing privileges are missing on the database file
> on
> > the remote server, right?
> >
> > any hints?
> >
> > Thanks
> >
> >
>
>
|
|
|
|