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 derfloh 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: *

  1. malleykr

    problem with formula column in reports

    Summary columns are what they sound like - a column that contains the sum of one of the other columns. Say you have a field F_TOTAL that is a column formula that multiplies QTY and PRICE. You could create a summary column CS_GRAND_TOTAL that sums the F_TOTAL field. Then you could put the...
  2. malleykr

    problem with formula column in reports

    Make sure that the placement of your CF field in the data model allows it to see the data it is using in the formula. For example, if your QTY1 and PRC1 fields are within the G_SALES group, try putting the CF field within the G_SALES group as well. Good luck.
  3. malleykr

    Selecting Between 2 dates

    Doh, my bad. I had the wrong thinking cap on. Try something like this instead: SELECT Table3.appStatusDate FROM Table3 WHERE (((Table3.appStatusDate)>=#30-09-2002 15:04#)) AND (((Table3.appStatusDate)<=#31-10-2002#)) The problem I see is that since your date format is in a different order...
  4. malleykr

    Selecting Between 2 dates

    Try something like this: select * from myTable a where a.appStatusDate between to_date('30-09-2002 15:04','DD-MM-YYYY HH24:MI') and to_date('31-10-2002','DD-MM-YYYY'); Good luck.
  5. malleykr

    Auto Decimal for percent format problem

    The problem is that the 'Percent' format always gives 2 decimal places. Try setting your format to the following instead: #.######% That should give you up to 6 decimal places, and it will convert numbers to a percent. Good luck.
  6. malleykr

    Comparing tables...

    Try this: 1.) Use the wizard to design a query that finds unmatched records based on one field, say CompId 2.) Open the query in design mode 3.) Create a new join for the other column (click on ElementId in one table and drag a link to the ElementId column in the second table) 4.) Highlight the...
  7. malleykr

    Loop question...

    Instead of: <CFIF IsDefined('qry1')> <CFLOOP QUERY = &quot;qry1&quot;> <CFHTMLHEAD TEXT = &quot; <META NAME = 'description' CONTENT = '#qry1.content#'> <META NAME = 'keywords' CONTENT = '#qry1.content#,'> &quot;> </CFLOOP> </CFIF> Try something like this: <cfset contents =...
  8. malleykr

    Simple SQL Question - Alias in Subquery

    Try something like this: select v.insid, cp.ProcsOutstanding from V_INS_ENTS_OUTSTANDING v, (select count(*) ProcsOutstanding, vmp.insid from v_monitored_procs vmp group by vmp.insid) cp where v.insid = cp.insid; Good luck.
  9. malleykr

    Why is this SQL statement not working correctly?

    The problem stems from the fact that null is not actually a value, but rather the absence of data. Because of this, you can not successfully compare it to a value. Access doesn't have a value, so it simply returns false to any inquiry containing null (other than a null=null relationship). If...
  10. malleykr

    Format mask...

    Try setting your format mask to $99,999.00 I'm not sure about forms6, but in forms 4.5 including the quotes around the format mask changed all the data to #########. Try leaving them off. Also, make sure to have five 9's before the decimal (instead of the four indicated in your post). A...
  11. malleykr

    query problem - access and oracle linked tables

    Try this instead: SELECT SURGERY.PTID, SURGERY.PTINIT, SURGERY.SURGDATE FROM SURGERY WHERE SURGERY.SURGDATE<DateValue('8/1/2000') ORDER BY SURGERY.PTID;
  12. malleykr

    Change the SQL ORDER BY ASC OR DESC clause via a form button

    Try something like the following: <cfparam name=&quot;URL.OrderClause&quot; default=&quot;Ascending&quot;> <cfquery Name=&quot;EmployeeSearch&quot; datasource=&quot;cftrain&quot;> select e.salary from employees e <cfif URL.OrderClause eq &quot;Ascending&quot;> order by salary <cfelse>...
  13. malleykr

    different session timeout values

    You might be able to. I have set up different timeout periods depending on the server the application is running on (devl vs. prod). My code looks like this. Note the setclientcookies=&quot;Yes&quot; text, I didn't notice it in your code. Since cookies are used to stored the session...
  14. malleykr

    'AOIndex' is not a index in this table...

    Not sure if it will solve your problem, but I did a search on Microsoft's technet for Access 2000 and AOIndex. It came up with the following article: http://support.microsoft.com/support/kb/articles/Q306/2/04.ASP Give that a shot, hopefully something in there will work out for you. Good luck! KR
  15. malleykr

    search long data type

    Kjell, The problem you are running into is the LONG datatype. There are many restrictions concerning LONG datatypes that do not occur with other text datatypes such as VARCHAR2. One of these restrictions is that a LONG field cannot occur in the WHERE clause of a select statement. For more...
  16. malleykr

    Oracle and Dates

    I don't know of a straight forward CF tag that will accomplish this for you, but the following code/logic will work: <!---Set the value of the two dates---> <cfset date1=&quot;11/01/2001&quot;> <cfset date2=&quot;12/01/2001&quot;> <!---Get the number of calendar days between the two dates--->...
  17. malleykr

    Setting value of List Box using PowerScript

    Hello. I have a form that requires the user to enter information. One of the fields on each of the records is an approval list box. The values contained are &quot;Proposed&quot;/&quot;N&quot; and &quot;Approved&quot;/&quot;Y&quot;. When the user changes the list box to &quot;Approved&quot...
  18. malleykr

    CFERROR Problem

    GunJack, Thanks, I did a little bit of a variation on your idea, and it should work pretty well. Here is the code I used: <textarea name=&quot;diagnostics&quot; rows=&quot;4&quot; cols=&quot;50&quot; wrap=&quot;virtual&quot; readonly>#Error.Diagnostics#</textarea> This way, the user sees it...
  19. malleykr

    CFERROR Problem

    Hi GJ. Turns out I was in a bit of a rush to leave yesterday, so the only functionality I had time to test was to see if the error message disappeared from my email form. I honestly cannot get either of our ideas to work (either the urlencodedformat or replace). I think the problem is...
  20. malleykr

    CFERROR Problem

    Actually, I found another way, right before I read your message. I used the URL_Encode() function to enclose the variable to prevent the problem you described. [code]<input type=&quot;hidden&quot; name=&quot;diagnostics&quot; value=&quot;#URL_Encode(ERROR.Diagnostics)#&quot;>[code] Thanks!!!

Part and Inventory Search

Back
Top