Jump to content

MCP

Members
  • Posts

    60
  • Joined

  • Last visited

    Never

Profile Information

  • Gender
    Not Telling

MCP's Achievements

Newbie

Newbie (1/5)

0

Reputation

  1. It works differently in Access. Where will the parameter be coming from?
  2. try this maybe? [code] <?php $sql = "SELECT DateDiff('d', (SELECT TOP 1 dhcp_log_date FROM dhcp_log ORDER BY dhcp_log_date ASC), GetDate())"; $result = mssql_query($sql); ?> [/code]
  3. hmm, you can switch by doing: alter schema <schema name> transfer <table name> i think everyone should be able to access the default dbo schema, so maybe use that? or maybe edit the guest.tableName tables to give yourself access? any of these ways should solve your issues. i wouldn't leave the production tables tied to your account schema, just in case someone else has to take over the project, and then all the names will have to be changed all over the code if you use 2 part names.
  4. Your single and double quotes look strange. Make sure they're: [code=php:0]"[/code] or [code=php:0]'[/code]
  5. To ease your future migration process, you might want to do this: (it's Barand's function, just renamed and wrapped in an if). This way when you upgrade to a version that has array_combine, then it should work seamlessly. [code=php:0] if (!function_exists('array_combine')) {     function array_combine ($a, $b)  {         $res = array();         $v = current($b);         foreach ($a as $k) {             $res[$k] = $v;             $v = next($b);         }         return $res;     } } [/code]
  6. And it wasn't after a 24 minute lull in you using that session, as specified by the gc_maxlifetime setting? Other than that, I'm stumped. Perhaps try upgrading to version 5.2.0, if possible?
  7. Strange on the sess_JAYMC. And you're not calling session_id with a parameter, right? Just for kicks, what happens if you assign another variable to your session? So something like $_SESSION['test'] = "test"; before the username assignment. Does the session id then become sess_test ? Also, what are the permissions on /SESSIONS ? How much space on that partition?
  8. You can leave sessions for as long as you want -- I don't think there's any technical restriction there. Are you saying that the garbage collection is the mechanism clearing out your session? Are you reaching the 24 minute mark and having your session deleted? Also, what do you mean by "session value"? What exactly does session_id() print?
  9. update table set col4=0, col5=0
  10. Also, you have session.gc_maxlifetime set to 1440 seconds, or 24 minutes. This is independent of the cookie lifetime and specifies how long your session lasts on the server before it's seen as garbage, to be taken out at each session_start with session.gc_probability/session.gc_divisor probability.
  11. [quote author=jaymc link=topic=121834.msg503557#msg503557 date=1168640686] But Ive been through all my scripts and the only thing they have regarding sessions is session_start(); $User_Session = $_SESSION['username']; [/quote] do you mean to say that you never save any variables to the session? how does $_SESSION['username'] get populated? sessions aren't truly created until you either assign something to the $_SESSION super global, or use session_register().
  12. try SELECT First_Name FROM Myname.customer or SELECT First_Name FROM [Domain\Myname].customer If it's a permissions issue, you would get a different error message -- this is definitely that the table is in a different schema. Alternately, you might try select * from information_schema.tables and see what it says in there
  13. Have you set the extensions directory appropriately? Do other extensions work? Which version of MS SQL?
  14. By default, SQL Server 2005 is not set up for sql security (will only use windows authentication). You'll have to enable this on your server if you haven't already...
  15. You can use multiple databases, but it would probably be easier if you kept a single database -- depending on your application, of course. You may want to look at row level security. Alternatively, you can do multiple databases, even at the same time: $db1 = mssql_connect("localhost","user","pass",true); $db2 = mssql_connect("localhost","user","pass",true); mssql_select_db("database1",$db1); mssql_select_db("database2",$db2);
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.