CodeCharge Studio
search Register Login  

Web Reports

Visually create Web Reports in PHP, ASP, .NET, Java, Perl and ColdFusion.
CodeCharge.com

YesSoftware Forums -> Archive -> CodeChargeStudio.Discussion

 Database command error

Print topic Send  topic

Author Message
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
> >
> >
>
>


   


These are Community Forums for users to exchange information.
If you would like to obtain technical product help please visit http://support.yessoftware.com.

PHP Reports

Visually create Web Reports in PHP, ASP, .NET, Java, Perl and ColdFusion.
CodeCharge.com

Home   |    Search   |    Members   |    Register   |    Login


Powered by UltraApps Forum created with CodeCharge Studio
Copyright © 2003-2004 by UltraApps.com  and YesSoftware, Inc.