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 gmmastros 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. willyd61

    CE10 - Reports via URL help..

    I am confused and in need of help. I want to initiate a report thru a URL. An application I have written emails a user once complete that reports can now be started. Instead I would like to have a link to the report. The report has 1 parameter. Reading around looks like unmanaged reports is...
  2. willyd61

    Managed URL reportings using NT Authentication in BOE XI

    Where do you find the valid parameters you can pass via URL. For example apsuser, id, etc.... . I want to initiate a report by passing the login credentials as well as the parameter as well.
  3. willyd61

    Changing an Excel Number field to a String

    That is crazy, There has to be a patch or workaround. I hate access, and I have spreadsheets the change to often. Until I came across this issue with linking to my oracle table threw the zipcode field. Does anyone know of a way around this and still link to the excel file? I don't want to...
  4. willyd61

    multidimensional array creation problem`

    Jeez, my bad... Here is the output I need......... 1st query give me array $main, then I my and clause finds the records that would associate. <?php $main[0] = "Application"; $main[1] = "Server"; $main[2] = "Network Device"; $main[3] = "Database"; $secondary[0][0] = "Crystal Enterprise"...
  5. willyd61

    Warning: mail(): SAFE MODE Restriction in effect.

    Try this... $tfrom = "From: {$nameVar}<$emailVar>\r\n"; $mailheaders = " MIME-Version: 1.0\r\n"; $mailheaders .= "Content-type: text/html; charset=iso-8859-1\r\n"; $mailheaders .= "$tfrom \r\n"; mail($to,$subject,$body,$mailheaders)
  6. willyd61

    Warning: mail(): SAFE MODE Restriction in effect.

    Well first you are missing the 1st header or the "From Header" at the beginning, ($headers = "From: \"Me\"<me@here.com>\n";) that makes it a malformed header. There should only be 4 args... $headers = "From: \"Me\"<me@here.com>\n"; $headers .= "MIME-Version: 1.0\n"; $headers .=...
  7. willyd61

    Problem with onLoad in BODY using PHP

    Just need to do this.... echo "<body bgcolor='#7692AC' onLoad=alert(\"Test\")>"; escape the double quotes, you had single quotes.
  8. willyd61

    multidimensional array creation problem`

    I was looking at my post, and thought it might be easier to simplify the question. I have one array built from a query, say like this... $main = array('foo','bar','test','one'); I then do a foreach($main as $i) { $sql = "select blah from blah where columna = '$i'; ) This is going to return...
  9. willyd61

    multidimensional array creation problem`

    Hey Guys, I am not very good at creating multi-dim arrays, What I am doing is doing a query, returning query results into a array, then for looping the next query based on the 1st array like so: (return_array is just all the oci stuff returning a array back) $sql = "SELECT...
  10. willyd61

    &quot;What's This&quot; / Help as user Data Dictionary? How?

    Depending on the type of database on the backend that you have, you can get this type info from there, we use TOAD for Oracle, and can see a schema browser to see the underlying tables, etc. RequestID is usually the primary key for evey form, besides that its how you dictate it. _WL
  11. willyd61

    Remedy as a stand alone product?

    You can download a demo license of the server with 3 person limit and less then 5000 records in the DB. But you can download and give it a go standalone on any server. I have put it on 133MGHZ Linux box's before, just have to keep in mind of the memory. Need at least 512MB
  12. willyd61

    How to Join Remedy tables using Crystal

    I do it 2 ways, one just creating a join form and report off that, which is how Remedy would tell you to do it. But thats a pain. So what I have done like stated above is just using the native odbc driver to my database and query the view directly. You will end up having to do some leg work...
  13. willyd61

    Almost Same Data Diffrerent Date

    any idea on how to make this happen? (recordid month1.cur1 month2.cur2 chcurr1 %curr)
  14. willyd61

    Almost Same Data Diffrerent Date

    Hmm.... That does work but I dont't seem to get any negative values. I am consfused big time now. I guess the easiest thing to get me back on track is to see see both months value and mark it. THis way I can see (recordid month1.cur1 month2.cur2 chcurr1 %curr) Know what I mean? Thanks...
  15. willyd61

    Almost Same Data Diffrerent Date

    bump
  16. willyd61

    Almost Same Data Diffrerent Date

    Not sure what you mean, what I have now is this. The fields mentioned above, with a record selection of the past 2 months. Then I group by RecordID. This gives me pairs of records. Then I do a min/max on the currency field I want to compare, then I use a group selection to suppress any...
  17. willyd61

    Almost Same Data Diffrerent Date

    bump
  18. willyd61

    Almost Same Data Diffrerent Date

    Bump..... I realized though that I can't determine when the amount changed. I would like to know if last months record to this months records was more expensive or cheaper????
  19. willyd61

    Almost Same Data Diffrerent Date

    Got it. I know have the record's that the min and max are not the same for the currency amount I am comparing. I realized though that I can't determine when the amount changed. I would like to know if last months record to this months records was more expensive or cheaper..... Once I do this I...
  20. willyd61

    Almost Same Data Diffrerent Date

    Thanks, I am almost complete, What I did was put the right clicked and did a summary on 1 of the currency fields, with min and max, put this in the group footer, and put in the group selection for the report that these can not equal eachother. I seem to still get ones that min and max...

Part and Inventory Search

Back
Top