Hi,
Yes, you're correct, email id name should contains one dot (.) and email id name starts with alphabets only, length would be minimum 5 chars and it is end with preferred domain names, all small letters, as I mentioned.
As like this...
Hi,
Yes, you're correct, email id name should contains one dot (.) and email id name starts with alphabets only, length would be minimum 5 chars and it is end with preferred domain names, all small letters, as I mentioned.
As like this...
Hi,
Noted, as per your directions, im developing, request you to please elaborate how I get Reponse ? the response values comes like 101 Sucess, 102 some inputs are missing, ... 106 err.
Can I use like this pls refer following my code ? and Check As Tasks I added As Tasks.task
Async Function XyxPushAsync(name As String, title As String, phone As String, file As Byte(), response As String) **As Tasks.Task**
Dim body = New With {.title = title, .name_applicant = name, .mobile = phone, .upload_file = file}
Dim respo As HttpResponseMessage = Await _client.PostAsJsonAsync("bel_crm_push_api.php", body)
respo.EnsureSuccessStatusCode()
End Function
Hi,
ref this sample data, after posting this data, I'm getting this error.
"title":"Mr","name_applicant":"RAMUDU","gender":"Male","marital_status":"Maried","occupation":"Student","income":"10,000 to 15,000",
"date_of_birth":"01/11/1991","address1":"Dharmasastha nagar","address2":"MAS","pin_code":"631502","state":"Tamil Nadu","district":"Kanchipuram","mobile":"9123456789","introducer_emp_code":"12345","emp_name":"ramudu","branch_code":"ACCAstha",
"branch_type":"ANB","crmbel_customerid":"undefined","crmbel_lead_id":"78996","status":"0","transaction_module":"399",
"nom_name":"UBALLU","nom_relation":"Spouse","nom_age":"41","proof_name":"Birth Certificate"
Hi,
My SQL version is Microsoft SQL Server 2016 (SP1-CU15-GDR) (KB4505221)
Hence I have created an FN, as follows,
CREATE FUNCTION [dbo].[SplitString]
(
@String NVARCHAR(4000),
@Delimiter NCHAR(1)
)
RETURNS TABLE
AS
RETURN
(
WITH Split(stpos,endpos)
AS(
SELECT 0 AS stpos, CHARINDEX(@Delimiter,@String) AS endpos
UNION ALL
SELECT endpos+1, CHARINDEX(@Delimiter,@String,endpos+1)
FROM Split
WHERE endpos > 0
)
SELECT 'Id' = ROW_NUMBER() OVER (ORDER BY (SELECT 1)),
'Value' = SUBSTRING(@String,stpos,COALESCE(NULLIF(endpos,0),LEN(@String)+1)-stpos)
FROM Split
)
And I added [dbo].[SplitString], code as follows.
from cte
......
cross apply [dbo].[SplitString](cast(DueDates as varchar),','))
....
Thanks.
Hi,
Please run the following code, you can get some idea.
select
row_number() over (order by VillageID) Sr,
VillageID, VillageName, sum(NoOfMembers) as NoOfMembers,
stuff((select concat(', ', DueDate) from
( select distinct DueDate from (
select * from #Temp where VillageID = t.VillageID ) p
unpivot (DueDate for d in (DueDate1, DueDate2, DueDate3, DueDate4, DueDate5)) u
) q
where DueDate <> 0
order by DueDate
for xml path('')), 1, 2, '') as DueDates
from #Temp t
group by VillageID, VillageName
order by VillageID
Hi
What's the preferred domain names?
For Security purpose, I shared dummy domain names, we can use like @abc.co.in @xml.com ...
Thanks for the response.