Aware IM User Forums

When I run a query like find all Students, I get the results list that shows all attributes of the Student object. It is possible to change the list so I only get a few attributes (e.g. name, studentid)?

cheers,

ski

Tom,

I get an error when trying to use Time_Add with mysql so I cannot use it. Your idea works find with derby though?

ski

I am not using drop down. I am using the table of items and showing between 5 - 20 items in the table at a time.

Whoops, I did not explain what I was trying to do well. I am starting from an AwareIM application and trying to call out to a perl function. For example, in my AwareIM application I create a new staff member. I then want to call a perl function that creates the directory on the file server. In the c...

I think I may have found the problem by watching the packets with ethereal. It looks like AwareIM expects to have a cookie passed back to it when you hit the successURL return. The cookie is set in the browser when the person is in operation mode. This is why when I put the url into the browser it w...

Do you randomize the return URLs for URL services. I have noticed in my testing that the return URL is always the same. This means that if I had two separate AwareIM business spaces running and they both accessed the same service, they could potentially get each other's return data as there doesn't ...

Ok, making progress. I was able to get values back into AwareIM. What threw me off was when you create the process, it will have a warning that the notification is possibly the wrong object because this is not a normal notification, but one that is created on the fly. My last problem is accessing th...

PS: all attributes in the previous post are reference attributes.

Ok, More testing. The matching attribute is the problem If I remove it from the classes tab and just leave in the attributes that are not matching, it only takes a few seconds to load a student. If I remove the attributes that are not matching and leave in the matching attribute, then it takes 12 - ...

Definitely scaling issues. I created a smaller test database with about 500 staff, 1000 students, and the groups/classes they need. The table sizes in BASTEST are (in records): ChangeLog: 17K Class: 1.4K Class_ref: 6.2K Group: 0.3K Group_ref: 7.6K Staff: 0.5K Staff_ref: 7.4K Student: 1.0K Student_re...

Why doesn't this work if Staff.LastModified > (Current-TimeStamp - 24) then do something. The minute I try any type of calculation in the query, the query becomes true and grabs all records. But I can create a separate object and do this: SystemSettings.LastUpdated = Current_TimeStamp - 24 if Staff....

Ok, it looks like for MySQL I can just add or subtract hours from a TimeStamp, but for Derby I have to use the Time_Add function. I still think a list of what functions are used with which database would be very useful though.

I get the ...Element Time_Add .... cannot be converted to the currently installed version of SQL. I have a few questions: 1. Is there a list of functions that do not work with MySQL so I can avoid them? 2. What are my options for manipulating timestamps with MySQL? Do I need to upgrade? Are there ot...

Tom,

I am still new and this and do not understand what you are asking for. What do you mean by 'Show ____ item'?

thanks for your help.

ski

Hi, I am running into problems opening a tab on a form. The tab opens onto a reference list and it just hangs until it times out. I checked the tables and I have the following: ChangeLog: 87K records Class_ref: 53K records Group_ref: 11K records Staff: 2.8K records Student: 20K records Student_ref: ...