Jump to content


dfoster

Member Since 27 Mar 2008
Offline Last Active Nov 10 2017 08:35 AM
-----

Posts I've Made

In Topic: Get Data from Custom Profile Field

15 July 2015 - 01:35 PM

Hi April sorry for that late response. The only way you can get that information would be to use a 3rd party tool in order to query the database directly.

 

If you do that, then you want to query the user_inf table and the P1.P2,P3..P10 values correspond to the Profile table opt_no values.

 

So for Profile field 1 it would be something like:

 

SELECT * FROM user_inf inner JOIN profile ON user_inf.p1 = Profile.opt_no


In Topic: Customized menu upon installation?

15 July 2015 - 12:32 PM

Hi Javier, sorry for the late reply.

 

With AccuSQL, you can create a blank database in SQL Server, then point to it in AccuSQL and set the configuration options the way you would like. You then use that database and in SQL Server management studio, merely backup then restore that database as many times as you would like with a different name. Each of the restored databases would have the configuration options set as you had them in the original database.