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!

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

Recent content by richiew13

  1. richiew13

    Using a variable in an UPDATE SQL query

    3. get your quoting style right, from the start. Personally I use heredoc for anything more than a couple of lines" I researched heredoc here: http://www.hudzilla.org/phpwiki/index.php?title=Heredoc_syntax Is heredoc something that needs to be installed or defined? Or, can I just start using...
  2. richiew13

    Using a variable in an UPDATE SQL query

    jpadie, thanks for the tips. Don, thanks for that code as well. I was sure there was a better way then what I was doing. I just wanted to try and do it within the confines of my existing knowledge. And even then I couldn't do it. I came here because I knew my method was on the right track...
  3. richiew13

    Using a variable in an UPDATE SQL query

    Thanks, jpadie. I figured there was a better way to do this straight from sql. But I figured I could write a script to do it easily. I was wrong. I am just now getting to learn how to use mysql with php. I've been reading books and tutorials slowly over the past couple of months. I can...
  4. richiew13

    Using a variable in an UPDATE SQL query

    Doesn't my code do the following: 1) set a variable ($num) equal to 1. 2) state that while the variable is less than 40, execute the following: 3) run the query based on $num being equal to 1. 4) set $num equal to 2. 5) return to step #2.
  5. richiew13

    Using a variable in an UPDATE SQL query

    I am in the process of teaching myself PHP/SQL. I have a seemingly simple thing I'm trying to do. I have a field called "memberid" in my database that is populated with a unique number for each row. I have another field called "member_id" that I want to populate with the same number that is...
  6. richiew13

    Adding linked parameter to subreport

    Where is the subreport linking screen? I am using CR 8.5. I only know about the Add Subreport screen. I already have a subreport, I just want to change the linking.
  7. richiew13

    Adding linked parameter to subreport

    I'm using Crystal 8.5. When I try using the formula you mentioned, I get a "The summary/running total field could not be created.
  8. richiew13

    Adding linked parameter to subreport

    ohhhhh....I see. Never thought of that. I will try both of your ideas. Thanks a bunch!
  9. richiew13

    Adding linked parameter to subreport

    Thanks, I will try the linking advice. The problem with your formula is that if I choose the date range of May 1 through May 31, and it turns out there is no data on May 1, my formula label would say "May 2 through May 31". And, although technically accurate, I think this may confuse my customers.
  10. richiew13

    Adding linked parameter to subreport

    I have a report and a subreport. I have one parameter, it is a date range. Instead of a date range I want to have a begin date and an end date for the report parameter. How do I add a linked parameter to a subreport? The reason I want to change the type is because I want to print the...
  11. richiew13

    Keeping an entire group on the same page

    I've developed a report that generally will fit 3 different groups on the same page. (Generally, each group is about 1/3 of a page in height.) However, if there are more than 2 details for any one of the groups, the third group will be split over to a second page. Is there a way to make sure...
  12. richiew13

    Add Command/Field Explorer

    lbass, thanks. I copied your version and pasted it and it worked. I know very little about SQL queries. It looks like your version has two changes from mine (which came straight from my book). You added: Customer. in front of each field, and you used " instead of '. What does each of...
  13. richiew13

    Add Command/Field Explorer

    I used this SQL query in the Add Command dialogue: SELECT "Customer Name", "Region", "Country", "Last Year's Sales" FROM Customer I did this on the Xtreme Database example that came with Crystal XI.
  14. richiew13

    Add Command/Field Explorer

    I have a crystaluser.com training guide. In the lesson about using the Add Command prompt, it tells me to access the sample database with a simple SQL statement in the Add Command function. In my guide, after I add the Command, it shows 4 fields with their original names as the titles...

Part and Inventory Search

Back
Top