Great Ideas. Always Flowing.

We are not happy until you are happy. Client satisfaction guaranteed. Whatever your needs and requirements, we have the skills and resources for the job!

Quick login...


Or... now make it easy with Facebook Integration
Connect via Facebook



Top Sellers

Frustrated over the lack of customization for your user's registration fields? Dynamically setup your DNN Portal with custom registration fields, layout, questions, and other core integration options......

Ultra Video Gallery is a brother product of Ultra Media Gallery, UVG allows you to upload videos in various format and automatically encode them to flv or H264 format, you also can add videos from internet or record live videos from your webcam.

Build high performance, completely customizable data-entry forms and views driven by your DNN and external databases. New built-in tools make it a snap to quickly create data entry forms, data views, and even database tables. Plus, add your own HTML, CSS, Javascript, SQL commands, stored procedures,

The most advanced DotNetNuke shopping cart on the planet. Easy to use e-Commerce, Secure Shopping Cart Software and SEO friendly. B2C / B2B Ecommerce Sites.

One stop solution for events calendar and events registration! FREE DOWNLOAD is available now!

Query String value to control search
Last Post 07-16-2010 10:32 AM by Chad Nash. 10 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
The DadUser is Offline
going with the flow
going with the flow
Posts:71
Avatar

--
05-22-2010 04:01 AM

    With DUD, is it possible to pass aquery string variable (i.e. ASID) and use it as search value for  userid?  I am trying to integrate with Active Social which passes  a userid to the module as ASID in the query string.  Can I use this variable as my search value  in DUD?

    Chad NashUser is Offline
    Posts:5260
    Avatar

    --
    05-26-2010 03:52 AM
    Hi. This isn't possible with DUD but I think you could do this with either Tailored Text/HTML or Dynamic Views.

    If needed we can add this as a new feature to the module (always lover to support integration with other 3rd party modules). What specifically would you need it to do? Show the detail view of a user if that ID is passed in, similar to what the detail view works now with the module?

    -Chad
    The DadUser is Offline
    going with the flow
    going with the flow
    Posts:71
    Avatar

    --
    05-29-2010 12:58 PM
    I simply want to show selected profile fields for the user passed via the query string (&asuid=nnn).

    I would then need to query profile data for that user. (i.e. WHERE userid=&asuid)..

    What would the SQL select statement look like to get Core and extended profile fields?

    I do not need detail data or export to Excel.

    I can then easily add the module to a tab in AS. The real key is using &asuid in the initial query. With this functionality I can place formatted data from any source on an Active Social tab.
    David ToUser is Offline
    river guide
    river guide
    Posts:2719
    Avatar

    --
    05-30-2010 07:22 AM
    HI, in this case you should consider using tailored HTML to retrieve the user's profile based on a querystring. -- David To
    The DadUser is Offline
    going with the flow
    going with the flow
    Posts:71
    Avatar

    --
    05-31-2010 07:57 AM
    OK. Where can I find an Example of a query that will fetch the profile fdata for a user?
    Chad NashUser is Offline
    Posts:5260
    Avatar

    --
    06-03-2010 12:44 PM
    Hi... Actually Tailored Text/HTML has a built in feature to display any and all user profile data built in (without having to use a querystring token).

    You can find out more about Tailored Text/HTML here:
    http://www.datasprings.com/Products...-HTML.aspx

    There is also a built in function within Tailored Text/HTML to allow you to reference SQL Tokens, and base the SQL on a querystring token as well.

    For more details on this you can try this page:
    http://www.datasprings.com/default....serID=5832

    -Chad
    The DadUser is Offline
    going with the flow
    going with the flow
    Posts:71
    Avatar

    --
    06-18-2010 11:46 AM
    I will check this out! Sounds great.
    The DadUser is Offline
    going with the flow
    going with the flow
    Posts:71
    Avatar

    --
    07-15-2010 02:49 PM
    Chad wrote:
    "Hi. This isn't possible with DUD but I think you could do this with either Tailored Text/HTML or Dynamic Views.

    If needed we can add this as a new feature to the module (always lover to support integration with other 3rd party modules). What specifically would you need it to do? Show the detail view of a user if that ID is passed in, similar to what the detail view works now with the module?"


    Tailored Text will not work for me as I need the module to display data from a provate table fetched from the initial sql. 

    DV will NOT ALLOW me to use a query string variable (i.e.asuid) other than DSParam1,,n unless I am missing something.

    I want to pass &asuid in the querystring and use it in my initial query for data.  This will give me the power to integrate DV with Active Social tabs!  How can I do this?
    Chad NashUser is Offline
    Posts:5260
    Avatar

    --
    07-16-2010 08:11 AM
    Hi there... A couple things.

    I am not clear on what you mean by this "I need the module to display data from a provate table fetched from the initial sql."? Can you explain more why Tailored Text wouldn't work since you can use any querystring variable within the SQL Binding?

    As far as Dynamic Views - You should be able to specify additional querystring variables in future releases, I know Ryan has been working on many new fun features for Dynamic Views 2.0 such as the ability to choose which fields to Export to Excel, a new feature to sort columns up and down for the export, a PDF Export, a Free Form SQL for external connections that are not SQL Server, along with some new features called 'Actions' which you can use for things such as deleting a record, updating a record etc... Ill see about also adding in a similar feature that Tailored Text has to allow for multiple / any querystring variables to be parsed.

    As far as DUD - We have added this to the list for the 3.1 release. We recently had to release a similar request (just ID instead of UserID in the querystring) for a client via some Premium Support hours and so we will likely add in the ASID for the next release in that same area of code.

    Thanks,

    Chad


    -Chad
    The DadUser is Offline
    going with the flow
    going with the flow
    Posts:71
    Avatar

    --
    07-16-2010 10:11 AM

    Chad wrote:

    I am not clear on what you mean by this "I need the module to display data from a provate table fetched from the initial sql."? Can you explain more why Tailored Text wouldn't work since you can use any querystring variable within the SQL Binding?


    I want to display multiple records from a private table, ala DV.  The initial SQL Bind in TT wants a single row returned.  As far as I know, there is no way in TT to display records from a query or stored proc like: 


    select * from privtbl where userid = $(ASID) and …


    As far as Dynamic Views - You should be able to specify additional querystring variables in future releases…


    Sounds great – just what I need!  How long B4 the querystring var portion is ready? 


    As far as DUD - We have added this to the list for the 3.1 release. We recently had to release a similar request (just ID instead of UserID in the querystring) for a client via some Premium Support hours and so we will likely add in the ASID for the next release in that same area of code.


    Great!  This will make DS Integration friendly to Active Social!  See new integration features from Ventrian; just released: http://www.ventrian.com/Support/Pro...aspx#56102

    Chad NashUser is Offline
    Posts:5260
    Avatar

    --
    07-16-2010 10:32 AM
    Thanks for the tips... Also, the latest release of Tailored Text did offer features to allow for unlimited rows for SQL Binds so you really should still be able to go in that direction.


    -Chad
    You are not authorized to post a reply.


     
     

    Join our mailing list...

    Get current news and events the easy way
    Subscribe Me

    Recent Blogs...

     
    Copyright 2005 - 2011 by Data Springs, Inc.
     
  • film izle
  • 720 izle
  • film
  • sinema izle
  • film makinesi
  • T�rk�e dublaj film
  • film izle
  • film izle
  • baglan film izle
  • sinema izle
  • 1080 film izle
  • film mercegi