but it returns nothing when the passed value is null and I do have null in the table!
here is my stored procedure:
JOIN assets$status ON `assets$status`.status_id = assets$audit.audit_status
LEFTJOIN assets$conditions ON `assets$conditions`.condition_id = assets$audit.audit_condition
WHERE item_id = param_item_id
AND location = param_loaction
AND floor = param_floor
AND room = param_room
AND department = param_department
AND employee = param_employee
ORDERBY audit_date DESC, created_date DESC;
Read and understand this visual explanation of sql joins[^] then you will have an idea of what is happening.
You may not have a null value in the table but you certainly have a left join which will return nulls if there is no corresponding row on the right side of the join.
“That which can be asserted without evidence, can be dismissed without evidence.”
In one table i am having 30 columns,in each column i mentioned data type as long text with character set as utf-8.When i am inserting the text from c# it only saving some limited number of characters,It is not saving full text.I want to insert long type text to almost to 30 columns I tried with changing different data types and character sets but not working.Please help me in getting this mysql problem.Example text from c# to insert in mysql column
I looked into a cursor approach for this replace function and have come up with the following below. However, I am still experiencing the same output error, as explained above. the function loops through continuously and creates duplicate names of hyperlinks, within the XML data.
DECLARE CUR CURSOR FAST_FORWARD FORSELECT name
Where UploadDate >= '2014-09-01'and@XMLLIKE'%' + Name + '%'OPEN CUR
WHILE1 = 1BEGINFETCH cur INTO@name--IF @Name IS NOT NULL IF@@fetch_status <> 0BREAKBEGINSELECT@XML = REPLACE(@XML,
'<a href="<a href="pagename.aspx?tag='+@Name+'">'+@Name+'</a>')
END--FETCH NEXT FROM CUR INTO @NameENDCLOSE CUR;
Please advice further, if possible.
Thank you for your help and time.