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: daddypost
  • Content: Threads
  • Order by date
  1. daddypost

    Need to use a field from one table in the where clause of another tabl

    I have a table promotion_schedule that has a field called "where clause". This actually has the where clause used to pull certain items out of another table. If I do a: select where_clause from promotion_schedule it will give me the following: ((acntv.master_sku.retail_cat='some...
  2. daddypost

    How to tell a cursor how to pull a specific record

    I have a cursor that pulls product_id and size and orders them by size asc. I'm passing a size and number(either 1 or 2) to the function. basically what I'm needing to do is return the size that is the next closest to the size I pass in. The issue becomes when I have more than 1 size...
  3. daddypost

    Help speeding up a function

    I have a sql query that pulls about 26000 rows in about 3 min. I have added another column that calls a pretty simple function, but it changes the efficiency to about 100 rows/2 minutes. I really need to add three columns using the same function, but at this rate, it would run all day. The...
  4. daddypost

    Syntax for calling a function inside a function

    I have a function that has three parameters(v-mid,P_product_id, n). Inside that function I need to call another function called top_related_prod_type2 that have the same three parameters that were passed to the main function. The synatx around it looks like this: if v_no_of_records < n then...
  5. daddypost

    looping nested cursors?

    Okay, I'm in a major crunch here. Here's what I have. There is a gui that allows users to select filter criteria. Each product group can have multiple groups with individual filters in it (ie. Gold month could have a gold rings shop,a gold necklace shop, etc each with their own filters)...
  6. daddypost

    carrying values over to nonexistint date fields

    hopefully the title was confusing enough to someone that they may look in to see what in the world I'm talking about. I have a table that contains product_ids, review_dates, and aggregated ratings. Here's what I need: I need to create a file that has every day(starting with the first date a...
  7. daddypost

    Can this be done without writing 100 queries

    Okay, I'll try to explain this as best as I can. I have a table which houses every product we have in stock and their properties. There are four fields that I'm interested in: Prod_type,Gemstone,Retail_cat, and Meterial. I need to find unique combination of the products based on 1,2,3,or 4 of...
  8. daddypost

    quick question about passing parameters to multiple procedures

    OK. I've got an initial procedure that can be passeed an optional date parameter. I need those parameters to be able to be passed to a procedure that is called within the first procedure. Then I need those to be passed again to a third procedure which is called from the second. Make since...
  9. daddypost

    Another Duplicate question. This time, a little more complicated

    Okay I've got a keyword. Under each keyword can be multiple retail categories with a specific number of orders per category. Keyword category orders diamond gemstones 100 diamond jewelry 20 diamond supplies 8 ruby...
  10. daddypost

    question with duplicates

    Okay, i've got a table that has duplicate rows(except one column). In other words, rows will have the same ID#(cookie), same visit_date, but different entry page. ie. 765-432 06-07-2007 affiliate 765-432 06-07-2007 search. I'm trying to find a way to combine these rows and make...
  11. daddypost

    procedure and parameter question. Not recognizing parameter

    I have the following the snippet of procedure the is using an existing table as a parameter, but every time I run it I get an error saying the "table doesn't exist" I guess it is not recognizing the parameter correctly. PLEASE HELP: create or replace procedure nc_new_customer_analysis...
  12. daddypost

    Using a variable as a tablename in from statement

    Okay, I'm new to writing in oracle, only VBA and SQL. Its normally pretty easy to define a variable and use it as a table to do a select from. I'm writing a procedure that will be used daily for 30 days, using a select from a table called nc_daily_new_customers. Once the month ends, I want it...
  13. daddypost

    VBA code to change text in exel charts

    I've inherited a workbook that has 1 data page, and 15+ charts. The text on each of the charts has been manually changed to reflect the month's data that is in the charts. I'm sure there is any easy way to do this through VBA, but I'm not sure of the syntax. My initial thought is just to do a...
  14. daddypost

    Need diff. way to link tbles besides cat.tables.append tbl

    i've currently got code automatically checking for passwords, and remote tables using cat.tables.append tbl. Our lan team just set up a locking scheme which apparently doesn't like what I'm using (long story short, it makes two unsuccessfull attempts at linking for every successful attempt and...
  15. daddypost

    Cat.tables.append problem. One call of this is producing 3 attempts

    I've got a large module which get a password and user ID string from a remote file. Everytime the database is opened the code runs and relinks the tables that are connected to sybase(as we change passwords frequently, this is the best way to not have to touch every database when there is a...
  16. daddypost

    Access VBA code to print excel chart not working

    Here is the code I have: Public Function openexcel() Dim xl As Excel.Application Dim sheet2 As Object Dim workbook As Object Set xl = CreateObject("excel.Application") xl.Workbooks.Open ("C:\last eight periods chart.xls") ' substitute your file here xl.Visible = True xl.DisplayAlerts = False...
  17. daddypost

    Need help writing code to print a chart in excel from access

    I've got a workbook called "Last eight periods chart". In this I have a pivot table linked to data in my mdb. I've gotten around the auto refresh dialog box by refreshing the workbook through code. However, now I need to print the chart to a pdf file. I cannot get anything to work. The...
  18. daddypost

    Need to paste a screenshot of data page to email through code

    I've got a data page in access that I need to take a screenshot of and email(the reason being if I email just the data page, when you open it, it contains only the template and no data). I'm able to get it to the clipboard using VBA: Private Declare Sub keybd_event Lib "user32.dll" _ (ByVal...
  19. daddypost

    Need to pass network login and pw into conection string

    I'm running some code from access that hits a sybase server. The code does some deleting and updating on the server. I've gotten everything to work the way I want it on out test server, but I had to hard code my password and login name in the connection string. The problem is that we don't...
  20. daddypost

    help with this code please. Runs WAY TO SLOW!!

    Okay, here was my first attempt at this code to connect to a sybase server, get a recordset of tables, find what column number contains records I need, and then inserting values into a local table. It works. HOWEVER, 1)I have open 3 connections to the same database throughout, 2)It runs slow...

Part and Inventory Search

Back
Top