Skip to main content

Posts

Showing posts from August, 2009

Calling a custom database function in WHERE part of your entity

I have encountered a need to call a custom database function in WHERE part of the entity using entityspaces(2008.x.x) which does not support Raw SQL Injection Everywhere . I have searched everywhere and posted inquiries in the friendly ES forum but theres no luck. This task can be done easily using stored procedure but I wanted to use ES for I have other filters, join and grouping, all of this are already in place except for the part where I need to call the function. Now LastQuery to the rescue, this property contains nothing until you make the query, so the idea is to call the query making sure that only one or zero record will be return then use the value of LastQuery to construct a new SQL Query/Statement with the datase function in it to be use in our entity custom load. I am not sure if this is a good practice but I works for me. See the code below. ' Make sure we only have one record for this load Dim esqUsers As New UserCollectionQuery("uv") es...

Grouping radio buttons the jQuery way.

I figured I’d share how to handle grouping of radio butons using jQuery. Color: Red Green Blue Favorite: jQuery VB.Net DotNetNuke Users: admin vreboton gabie Or Groups: Subscribers Managers Guest All you need to do is use the same value for the GroupName attribute of your radio buttons. Red Green Blue Then insert the script below into your page: <script language="javascript" src="http://vreboton.googlepages.com/jquery-1.3.2.min.js"></script> <script language="javascript" src="http://vreboton.googlepages.com/jquery.vreboton.UniqueRadioButton.js"></script>