Database

where 
       !string.IsNullOrEmpty(record.Field<string>("userpk")) 
       ? record.Field<string>("userpk") 
       : null

Member 8003276 wrote:

a network related or instance specific error has occured

Bastard Programmer from Hell

a2bj wrote:

you should the check the host, user name and password in your configuration and make sure that they correspond to the information given by the administrator of the MYSQL server

jrahma wrote:

something like this (but throwing error!)

Bastard Programmer from Hell

select ('973' + contact_moblle) AS mobile_number from persons where contact_moblle is not null and contact_moblle != '' and len(contact_moblle) = 8 and left(contact_moblle, 1) = '3' GROUP BY contact_moblle order by file_no

;With CTE AS
(
	Select 
	     Rn = Row_Number() Over(Partition By ('973' + contact_moblle) Order By file_no)
	     ,('973' + contact_moblle) AS mobile_number 
	from persons 
	where contact_moblle is not null 
	and contact_moblle != '' 
	and len(contact_moblle) = 8 
	and left(contact_moblle, 1) = '3' 
)

Select mobile_number
From CTE
Where Rn = 1

select regexp_replace(d_name,'Mc[a-z]', 'Mc' || upper(substr(d_name, 3, 1))) n from
(
select 'Mcfix' d_name from dual
);

Stan Moong wrote:

reporting application