-
as seen on Stack Overflow
- Search for 'Stack Overflow'
New to subsonic and having issues figuring it out. I am simply just trying to do a distinct search and any documentation I find is telling me to use the class/method
SubSonic.SqlQuery
Though I am finding out that since I am using the newest version, a lot of the documentation I am finding does not…
>>> More
-
as seen on Stack Overflow
- Search for 'Stack Overflow'
Hi,
I need to update a joined sub-class. Since Hibernate doesn't allow to update joined sub-classes in hql or named-query I want to do it via SQL. I also can't use a sql named-query because updates via named-query are not supported in Hibernate.
So I decided to use a SQLQuery. But Hibernate complaints…
>>> More
-
as seen on Stack Overflow
- Search for 'Stack Overflow'
I'm using Code First and am trying to call a stored procedure and have it map to one of my classes. I created a stored procedure, BOMComponentChild, that returns details of a Component with information of its hierarchy in PartsPath and MyPath. I have a class for the output of this stored procedure…
>>> More
-
as seen on Stack Overflow
- Search for 'Stack Overflow'
In Silverstripe 3, I'm trying to run some custom SQL and return the result for handling in my template:
function getListings(){
$sqlQuery = new SQLQuery();
$sqlQuery->setFrom('ListingCategory_Listings');
$sqlQuery->selectField('*');
$sqlQuery->addLeftJoin('Listing'…
>>> More
-
as seen on Stack Overflow
- Search for 'Stack Overflow'
hey guys, just having a bit of difficulty with a query, i'm trying to figure out how to show the most popular naturopath that has been visited in a centre. My tables look as follows;
Patient(patientId, name, gender, DoB, address, state,postcode, homePhone, businessPhone, maritalStatus, occupation…
>>> More