You searched for the word(s): userid:422569

More Search Options

RSS Available

• Re: SQLGridSelectView Drill down

  Well I was wrong, Brian had set the module correctly. He had discovered a "feature". I have released a bug-fix for "Wait on Above" featrue of SQLGridSelectedView (V3.4f). So if you want to usses this feature or are having trouble getting it to work - download the modules from www.tressleworks.ca /Paul.

  Posted to DotNetNuke (Forum) by PScarlett on 4/24/2006

• Re: SQLGridSelectView Drill down

  I have exchanged e-mails with Brian and believe the issue requires the last filter not to have the Wait on Above feature enabled. Paul.

  Posted to DotNetNuke (Forum) by PScarlett on 4/22/2006

• Re: Connection to an external SQL Database whit DNN 4x

  Hily, Try using a module such as SQLView from DNNStuff or SQLGridSelectedView from www.tressleworks.ca to verify you database access. Once you can view the data in either of these modules, you should be able to access the database table from your code. Paul

  Posted to Getting Started (Forum) by PScarlett on 3/29/2006

• Re: New Version of SQLGridSelectedView

  Cliff, I have had several users ask the same questions. Since I do not experience the problem, I don't know how to fix it. The only user feedback I have related to the Trust Level setting. If you solve this... please share with the world. Thanks. Paul.

  Posted to DotNetNuke (Forum) by PScarlett on 3/28/2006

• Re: New Version of SQLGridSelectedView

  The issue of the Single quote in the select is easy to fix, but opens some giant SQL injections issues. If I assume that I just add a single quote to any single quote found, then I need to be careful of the situation of two single quotes in a row... where do you stop. I will review what I am doing an see if there is "clean" way to handle the Irish name issue. I will await you feedback and see what I can do. Paul.

  Posted to DotNetNuke (Forum) by PScarlett on 3/28/2006

• Re: New Version of SQLGridSelectedView

  Check the complete error displayed in the log viewer and you may see a reference to reflection in the method (i believe). If so the only solution I am aware of is changing the trust level to "high". Beyond that I would verify the permission are correct. Wish I could be of more help as I believe many first time DNNer get this problem and walk away from DNN I would like to have a solution and or at least a better answer. Good Luck. Paul.

  Posted to DotNetNuke (Forum) by PScarlett on 3/26/2006

• Re: New Version of SQLGridSelectedView

  This issue here is not really a bug, although I agree it doesn't work. The single quote in "O'Connor" causes a problem in the syntax of the generated SQL. This is a problem you may find with other modules depending on the complexity of the query. For the moment, try O''Connor (two single quotes) and see if that works. Uncheck the SQL injection checking as I will strip the pair of single qoutes if that option is enabled. Please send me an export your settings and/or a screen shot and I will see if

  Posted to DotNetNuke (Forum) by PScarlett on 3/26/2006

• New Version of SQLGridSelectedView

  SQLGridSelectedView V3.4 e is now available at http://www.tressleworks.ca/Default.aspx?tabid=82 . It's free once registered. SQLGridSelectedView provides the user with many options to select and display information from a SQL-capable database. Latest version of SQLGridSelectedView - contains several new features requested by users. 1) Calendar option on Date Selection Filter 2) Filter Selections allow different display text and selection value on dropdowns 3) Single "Go" Button with the ability to

  Posted to DotNetNuke (Forum) by PScarlett on 3/25/2006

• Re: sql syntax

  Old VB6 habits die hard... and to be honest am not sure if it still is important to use the "&". The & is used for string concatination while the + does object addition and this requires abit more processing to determine the object's string value. Paul.

  Posted to Custom Modules (Forum) by PScarlett on 3/21/2006

• Re: sql syntax

  You may want to look at the free Module at SQLGridSelectedView. This module accepts passed-in query parameters and also supports user text search values. Refer to the User Guide the for various substitutions allowed. You can also display the generated SQL to view how the module generated the displayed grid. This can be helpful in verifing the SQL results prior to coding your own module. You will find it at www.tressleworks.ca Enjoy. Paul.

  Posted to Custom Modules (Forum) by PScarlett on 3/20/2006