If this is your first visit, check our documentation. To post, register or login.
Forums / General Questions / Files containing SQL queries

Files containing SQL queries

Locked

Started by gnotapipe on 5 Jul 2006, 6:12 PM · Views: 1,308

Results 1 to 8 of 8
This thread is locked. New replies are disabled.
5 Jul 2006, 6:12 PM
#1
gnotapipe avatar

gnotapipe

New Zenner

Join Date:
May 2006
Location:
Oregon, USA
Posts:
33
Plugin Contributions:
0

Files containing SQL queries

Could someone point me to the file(s) within ZC containing the SQL queries/statements? (Not to do with the install.)

I'm particularly interested in queries relating to adding or updating products. So INSERT, UPDATE statements relating to the products, products_description, products_attributes, products_to_categories, etc tables.

Purpose: I need to create a super simple process to add or update products for some very non-tech users.

Thanks!

5 Jul 2006, 6:20 PM
#2
ajeh avatar

ajeh

Oba-san

Join Date:
Sep 2003
Location:
Ohio
Posts:
62,757
Plugin Contributions:
1

Re: Files containing SQL queries

Go to the Admin ... Tools ... Developer's Tool Kit ...

In the bottom input box type in: INSERT

Select Catalog, Admin or Catalog/Admin ...

Click Search ...

Voila! Tons to choose from ... :cool:

Now do the same with UPDATE ...

Linda McGrath
If you have to think ... you haven't been zenned ...

**Did YOU buy the Zen Cart Team a cup of coffee and a donut today? Just click here to support the Zen Cart Team!!**

Are you using the latest? Perhaps you've a problem that's fixed in the latest version: [Upgrade today!]
Officially PayPal-Certified! Just click here

Try our Zen Cart Recommended Services - Hosting, Payment and more ...
Signup for our Announcements Forums to stay up to date on important changes and updates!

5 Jul 2006, 9:21 PM
#3
gnotapipe avatar

gnotapipe

New Zenner

Join Date:
May 2006
Location:
Oregon, USA
Posts:
33
Plugin Contributions:
0

Re: Files containing SQL queries

Doh! Shoulda thought of that.
Of course, 'tons' was a little bit what I was trying to avoid... :wink2:
Thanks!

5 Jul 2006, 9:42 PM
#4
gnotapipe avatar

gnotapipe

New Zenner

Join Date:
May 2006
Location:
Oregon, USA
Posts:
33
Plugin Contributions:
0

Re: Files containing SQL queries

For curiousity's sake, to whomever would know & has time & inclination:

I note that in the standard admin/product.php page output a couple of the input names are done as arrays (e.g., 'name="products_name[1]"').
Just curious about the thinking behind this as opposed to doing them as simple vars.
thx...

6 Jul 2006, 7:34 AM
#5
superprg avatar

superprg

Totally Zenned

Join Date:
Feb 2006
Location:
Chicago
Posts:
1,349
Plugin Contributions:
0

Re: Files containing SQL queries

I dont see any such lines in admin/products.php
name="products_name[1]"').
Can you explain again what you are talking about? :(

Tutorials on Zen Cart
http://tutorials.zen-cart.com/index.php

advanced.programmer at gmail dot com
In love with Zen Cart!!

6 Jul 2006, 5:07 PM
#6
gnotapipe avatar

gnotapipe

New Zenner

Join Date:
May 2006
Location:
Oregon, USA
Posts:
33
Plugin Contributions:
0

Re: Files containing SQL queries

I should have been clearer. I was referring to the output as received in the client browser.

6 Jul 2006, 6:01 PM
#7
drbyte avatar

drbyte

Sensei

Join Date:
Jan 2004
Posts:
63,512
Plugin Contributions:
176

Re: Files containing SQL queries

That's to support multiple languages

.
Zen Cart - putting the dream of business ownership within reach of anyone!
Donate to: DrByte directly or to the Zen Cart team as a whole

Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.

6 Jul 2006, 6:03 PM
#8
gnotapipe avatar

gnotapipe

New Zenner

Join Date:
May 2006
Location:
Oregon, USA
Posts:
33
Plugin Contributions:
0

Re: Files containing SQL queries

Ah!
Thanks, DrB.