Recent content by ORettinger

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

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.)

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

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

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?

Did you configure your reconciliation keys correctly?

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

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

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

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

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

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

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

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

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