I use the following piece of code to fetch data from database. This
code is called from javascript by proxy (AjaxAction).
The problem is that the page once loaded doesn't show updated/deleted
records (after refresh of course), even they have been changed in
background (using ie. sql managment studio). It seems like data is
cached somewhere. What can I do in order to get data refreshed
everytime I call the following code?
string sql = @"
SELECT
address.CityId.Name, address.StreetId.Name,
address.StreetNumber, place.Numer,
place.Opis, parking.Opis, place.Id, category.Name ,
place.UzytkownikId.Login, place.ParkingId.Id
FROM
PParking parking JOIN parking.MiejscaPostojowes place JOIN
parking.AddressId address
JOIN place.CategoryId category
WHERE
place.UzytkownikId.Id = :userId
GROUP BY
address.CityId.Name, address.StreetId.Name,
address.StreetNumber, place.Numer,
place.Opis, parking.Opis, place.Id,
category.Name,place.UzytkownikId.Login, place.ParkingId.Id
";
SimpleQuery query = new SimpleQuery(typeof(PMiejsce), typeof
(object), sql);
DateTime currentTime = DateTime.Now;
query.SetParameter("userId", userId);
return (object[])ExecuteQuery(query);
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"Castle Project Users" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/castle-project-users?hl=en
-~----------~----~----~----~------~----~------~--~---
