Search results for query: *

I am trying to write a function that will take the average of a number of columns (rather than average of column in a number of rows)(trying to ghost a SAS function called mean) select meanof('var1,var2,var3') from mytable on data (var1,var2,var3) 2,4,6 6,8,10 would return...

I am attempting to convert myself from MySQL to Sybase ... and would appreciate your help ... I am trying to specify autoincrement columns and primary keys etc... in a select into statemment In Mysql: create table myrank (rank int(8) unsigned not null autoincrement, primary key...

I use the set column type a lot mysetcol set("a","b","c") Does anyone know if you can make it case sensitive mysetcol set("a","A","b","B","c","C") Basically I would like to get this to work .. create table t ( mycharcol char(1), mysetcol set("a","A","b","B","c","C") ); insert into t...

I am having a problem with client authentication getting client certificates to work - Have installed the client certificate in internet explorer, this also installs the server certificate as a 'trusted root certificate'. When access basic https area of website all works correctly, when...

I have a page generated by a php script that creates n tables each with their own submit button echo &quot;form type='POST' target='secondphppage.php'&quot;; for $i=0 to n echo &quot;<input type='submit' value='button$i'>&quot;; echo &quot;<input type='hidden' name='queryarray[]'...

I am trying to select a particluar row with the maximum score from a group of records - sounds simple maybe it is but it has got me so any suggestions would be very much appreciated from myfile ------ fkey,urn,score 1,1002,80 1,1003,100 2,2004,100 2,2005,80 3,3006,100 4,4007,80 I want to get...