Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: Silx
  • Order by date
  1. Silx

    Need help with group_concat query

    Huh, can't edit post. This is what creates the array in php: // Get all categories $categories_query = tep_db_query("SELECT * FROM (" . TABLE_CATEGORIES . ") LEFT JOIN " . TABLE_CATEGORIES_DESCRIPTION . " ON ( " . TABLE_CATEGORIES_DESCRIPTION . ".categories_id = " . TABLE_CATEGORIES ...
  2. Silx

    Need help with group_concat query

    Here is the php code for this: // Function to get category with full path function get_full_cat($cat_id, $CATEGORY_ARR) { $item_arr = $CATEGORY_ARR[$cat_id]; $cat_name = $item_arr['categories_name']; while (sizeof($CATEGORY_ARR[$item_arr['parent_id']]) > 0 &&...
  3. Silx

    Need help with group_concat query

    Hmm. Maybe it would be easier just to create a temporary table that would consist of the trees in a static form? Or is there a way to programmatically stop traversing once there are no more categories using sql?
  4. Silx

    Need help with group_concat query

    Did my explanation make sense? The product is at the furthest point in the linear tree, so in the case above, it would be in printers. The only way to retrieve the names of the parent categories is to look at parent_id for each one as you work backwards until parent_id=0 for the category in...
  5. Silx

    Need help with group_concat query

    Ah, good point. Tree is a poor choice of word. The 'tree' is really just a linear line. A product is put into a category. That category may have a parent category, it may not. The field should look something like this: Computers > Peripherals > Printers The item will only be in the printers...
  6. Silx

    Need help with group_concat query

    Alright, Rudy! Now we're getting somewhere. The names are being filled into that field. However, after further investigation into how the oscommerce system works, it seems that the categories are tree-based. There is a column in categories called parent_id. If the parent_id is 0, there is no...
  7. Silx

    Need help with group_concat query

    I'm not sure what I added was right, as its taking eons to process. use oscommerce SELECT manufacturers.manufacturers_name AS manufacturer , products.products_id AS id , products_description.products_name AS title , CONCAT('store/product_info.php?product_id=' ...
  8. Silx

    Need help with group_concat query

    I don't know how you guys do it. Machines! There's one thing I forgot to mention. To get to the category descriptions, there are 2 tables. categories categories_description categories.categories_id = categories_description.categories_id categories_description.categories_name is where the...
  9. Silx

    Need help with group_concat query

    Before I go into it, let me state that I've received terrific assistance from this site before.. and it's now the first place I come to when researching query issues! I'm working on a query that pulls from an OSCommerce database for products. Specifically, there are 4 tables I'm working with...
    • Silx
    • Thread
    • Replies: 13
    • Forum: MySQL
  10. Silx

    Could not insert a row larger than the page size into a hash table.

    I think I may need some assistance in getting the TSQL code wrapped up. I've got a basic select statement working here: CREATE PROCEDURE v2_Forum_Search @searchphrases_input varchar(255), @search_descriptions_toggle bit, @search_titles_toggle bit, @forum_ID int...
  11. Silx

    Timeout Errors

    The ODBC SQL server driver came from the first connection string, Driver={SQL Server}. My guess is, that 'driver' is ODBC? Also, I've tried to use SQLNCLI, but the provider does not seem to be installed on my host machine. Is that 2005?
  12. Silx

    Timeout Errors

    Oh, absolutely. I'll post both that I've been using: 'C_STRING = "Driver={SQL Server};" & _ '"Server=xxxxx;" & _ '"Database=gb;" & _ '"Uid=xxxxx;" & _ '"Pwd=xxxxxx;" 'Changed providers to try and fix timeout errors. 6/2009 C_STRING = "Provider=sqloledb;" & _ "Data Source=xxxxx;" & _...
  13. Silx

    Timeout Errors

    I don't have direct access, but I may be able to pull data from sys.sysprocesses. Someone mentioned to me that this may just be an issue with microsoft's drivers, and classic asp and that it cannot be fixed because it's old technology. I'm having a hard time believing that though.
  14. Silx

    Timeout Errors

    Every so often, I'll get timeout errors on my site.. and they seem to be fairly random. They'll occur when a query is being run, or purely just trying to connect to the database. Here is an example of the error: ASP Error occurred 6/15/2009 1:05:33 AM in Microsoft OLE DB Provider for ODBC...
  15. Silx

    Reporting tools

    I believe you can do this with ODBC. Excel has the ability to pull data from a database. So essentially, Excel becomes your reporting tool. Of course, I don't have excel on this machine, but I know I've seen examples of this around the 'net.
  16. Silx

    Could not insert a row larger than the page size into a hash table.

    One of the difficulties of using SP's with a requirement like this is its lack of array support (grrr!) I imagine your suggestion of passing the search terms via a comma delimited string is because of that problem, right?
  17. Silx

    Could not insert a row larger than the page size into a hash table.

    Greets! Actually, this involves ASP as well, but I didn't want to cross-post to multiple categories. Let me know if I should. I am getting the following error in my logs when folks search on my site: ASP Error occurred 6/12/2009 12:25:23 PM in Microsoft OLE DB Provider for ODBC Drivers Error...
  18. Silx

    'Replace' and RegExp question

    I think I spoke too soon. After testing, it looks like it's replacing the <br>'s throughout the text. Even if they're outside the tags. hmm.
  19. Silx

    'Replace' and RegExp question

    Works like a CHARM! Wish I could give you more than 1 thanks. :D I really appreciate the help. tek-tips.com always seems to come through with the help I need. cheers!
  20. Silx

    'Replace' and RegExp question

    Greetings all. I'm looking for some assistance in a small vbscript problem that has my mind bending into pretzels. :x Let's say we have a string like this: "abcdefghijklmnop <br> abcdefghijklmnop <br> abcdefghijk abcdefghijklmnopqr <br> abcdefghijklmnop <br> abcdefghijklmnop <br>...

Part and Inventory Search

Back
Top