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 SkipVought 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. ORettinger

    Hide a page. (AC432)

    First you should not mix up fields from different tables on one page if not really necessary Of course there will be errors if the overflow-link for computers does not exist. Try to work with the filter settings within AC DBA for screen design to avoid this (like not showing the page if it is...
  2. ORettinger

    How to automaticly update screen?

    Check out amOpenScreen() and use it within the FINISH.DO of your wizard. This will open a new screen with your prefered settings (i.e. filters etc.)
  3. ORettinger

    email connector to SC5

    Why are you still trying to do it through SC Auto? As I know SCAuto is still supported, but Peregrine seems to push its customers to connect-it. If you want to open a ticket from a web application, why don't you try to use connect-it together with a self-implemented eventin-queue in SC? So...
  4. ORettinger

    link issues on custom screens

    Maybe this is the solution: if you could change the Brand, you would not change an information of the Asset but of the linked model. But for changes regarding Models you should consult a screen for amModel not for amAsset or amPortfolio
  5. ORettinger

    Help sending a form via email

    If you just need a small Mail you also could use the function bool mail(string to, string subject, string message [, string additional_headers]) for this. PHP-Mailer seems to be a little bit oversized for this rather small requirement, don't you think?
  6. ORettinger

    Use of Connect-it : create a ticket from an XML file

    Did you configure your reconciliation keys correctly?
  7. ORettinger

    Nested selects in mySQL with PHP?

    SELECT userpermissions.location_id ,locations.loc_name FROM locations WHERE userpermissions.location_id IN (SELECT userpermissions.userid FROM userpermissions WHERE userpermissions.userid = '4') Don't you miss anything in your "FROM"-Part? SELECT userpermissions.location_id...
  8. ORettinger

    AC Ticket creation from intranet

    Your description is a bit small in my opinion. I'm not sure what you want to do ... Why don't you just use Connect-It as the layer between your intranet (Webserver with html-forms I suppose) and AC. Let the form/html send a mail to a special account and then use connect-it to transfer them...
  9. ORettinger

    Restoring Carriage Returns from Mysql PHP onto HTML

    If your Newline characters are stored in the database (as they normally are) try the command echo nl2br($textstring); PHP replaces everly \nl with an <br>-Tag That should do it
  10. ORettinger

    SET or Values?

    This $sql = "INSERT INTO Jokes SET " . "JokeText = $joketext, " . "JokeDate = CURDATE()"; will not work. SET is normally used to UPDATE data, not to insert. $joketext must be surrounded by single-quotes as it is a string So it should go like $sql = "INSERT INTO...
  11. ORettinger

    Change background color of a row

    if ($value==1) { echo"<tr bgcolor=colorA>"; } else { echo"<tr bgcolor=colorB>"; } Is this what you need?
  12. ORettinger

    Read variable from mysql_database

    Now I got it: You stored this sring-value in the database: "<table><tr><td>$hello</td></tr></table>" and now you want to echo your result and this $hello should contain your "Hi whats up" ... That sounds quite tricky ... I'm not sure if it is possible then. I would use a workaround like...
  13. ORettinger

    AC import script take much longer to import 2000 records in 1 hour

    Just a few ideas: - Is your server module "update table statistics" runned on a schedule (like once a day)? updating these statistics will speed up imports a lot - Can you map your dAssignment to another field (text-field), so AC doesn't need to convert String to Date, which is quite...
  14. ORettinger

    Rather Interesting Question - if at all possible

    Just try a subquery like "Select max(COLUMN3) from TABLE" and remember that value in a variable like $max_value If you then put an if-statement to your output like if $row[COLUMN3] = $max_value { echo "<b>" . $row[COLUMN3] . "</b>"; } else { echo $row[COLUMN3]; } that should do it
  15. ORettinger

    need help with required field

    I'm not sure what you need your form for. There are different ways to deal with this: - Maybe you should try a form validator like there a thousands written in Java-Script. - If this is not what you can go along with, you should declare one (the first) radio button as selected. So the error...
  16. ORettinger

    Removing large whitespaces in middle of text

    Well, i asume you always have more than 2 whitespaces between your two text parts. So you should try something like $newtext=ereg_replace(" ", "", $oldtext) this should erase all "double-whitespaces" by replacing them with an empty string. I'm not sure if it works 'cause I don't have a...
  17. ORettinger

    Problem Getting to BigBrother Page

    Did you check your <Directory> settings within your httpd.conf?
  18. ORettinger

    coloring text in a textarea

    CSS can do this! Just add something like textarea { color:#0000CC; } to your CSS definitions. ... and now back to PHP :-)
  19. ORettinger

    Semi Basic If/then question

    I would take $x1>=11 and $x1<=46 if you want 11 and 46 included

Part and Inventory Search

Back
Top