Click here to Skip to main content
15,504,549 members
Home / Discussions / Database
   

Database

 
QuestionProblem reading null Pin
Jassim Rahma21-Nov-14 1:25
Jassim Rahma21-Nov-14 1:25 
AnswerRe: Problem reading null Pin
Chris Quinn21-Nov-14 1:50
Chris Quinn21-Nov-14 1:50 
AnswerRe: Problem reading null Pin
Jörgen Andersson21-Nov-14 2:33
professionalJörgen Andersson21-Nov-14 2:33 
GeneralRe: Problem reading null Pin
Jassim Rahma21-Nov-14 3:51
Jassim Rahma21-Nov-14 3:51 
GeneralRe: Problem reading null Pin
Jörgen Andersson21-Nov-14 4:39
professionalJörgen Andersson21-Nov-14 4:39 
GeneralRe: Problem reading null Pin
Jassim Rahma21-Nov-14 5:38
Jassim Rahma21-Nov-14 5:38 
GeneralRe: Problem reading null Pin
GuyThiebaut21-Nov-14 5:53
professionalGuyThiebaut21-Nov-14 5:53 
GeneralRe: Problem reading null Pin
Jassim Rahma21-Nov-14 6:05
Jassim Rahma21-Nov-14 6:05 
GuyThiebaut wrote:
is valid.


but it returns nothing when the passed value is null and I do have null in the table!

here is my stored procedure:

SQL
SELECT assets$audit.audit_id,
   assets$audit.audit_date,
   assets$status.status_name,
   assets$conditions.condition_name,
   assets$audit.quantity
FROM assets$audit
JOIN assets$status ON `assets$status`.status_id = assets$audit.audit_status
LEFT JOIN 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
ORDER BY audit_date DESC, created_date DESC;



Technology News @ www.JassimRahma.com

GeneralRe: Problem reading null Pin
GuyThiebaut21-Nov-14 6:48
professionalGuyThiebaut21-Nov-14 6:48 
GeneralRe: Problem reading null Pin
Jassim Rahma21-Nov-14 9:02
Jassim Rahma21-Nov-14 9:02 
GeneralRe: Problem reading null Pin
Jassim Rahma21-Nov-14 6:17
Jassim Rahma21-Nov-14 6:17 
GeneralRe: Problem reading null Pin
Jörgen Andersson21-Nov-14 7:02
professionalJörgen Andersson21-Nov-14 7:02 
GeneralRe: Problem reading null Pin
GuyThiebaut21-Nov-14 5:45
professionalGuyThiebaut21-Nov-14 5:45 
AnswerRe: Problem reading null Pin
Smart00328-Nov-14 5:47
professionalSmart00328-Nov-14 5:47 
Questionmysql decimal fromat like ##.## Pin
Gilbert Consellado20-Nov-14 14:12
professionalGilbert Consellado20-Nov-14 14:12 
AnswerRe: mysql decimal fromat like ##.## Pin
Richard Andrew x6420-Nov-14 16:47
professionalRichard Andrew x6420-Nov-14 16:47 
GeneralRe: mysql decimal fromat like ##.## Pin
Gilbert Consellado22-Nov-14 14:46
professionalGilbert Consellado22-Nov-14 14:46 
AnswerRe: mysql decimal fromat like ##.## Pin
Shweta N Mishra21-Nov-14 6:50
professionalShweta N Mishra21-Nov-14 6:50 
GeneralRe: mysql decimal fromat like ##.## Pin
Gilbert Consellado22-Nov-14 14:43
professionalGilbert Consellado22-Nov-14 14:43 
GeneralRe: mysql decimal fromat like ##.## Pin
Shweta N Mishra23-Nov-14 3:06
professionalShweta N Mishra23-Nov-14 3:06 
GeneralRe: mysql decimal fromat like ##.## Pin
Gilbert Consellado24-Nov-14 13:47
professionalGilbert Consellado24-Nov-14 13:47 
QuestionProblem in Insering Long text in mysql from c# Pin
Ramachandra12720-Nov-14 8:09
Ramachandra12720-Nov-14 8:09 
GeneralRe: Problem in Insering Long text in mysql from c# Pin
PIEBALDconsult20-Nov-14 8:33
professionalPIEBALDconsult20-Nov-14 8:33 
QuestionSQL Replace Function - error recognizing two or more strings Pin
miss78618-Nov-14 0:44
miss78618-Nov-14 0:44 
AnswerRe: SQL Replace Function - error recognizing two or more strings Pin
Richard Deeming18-Nov-14 3:53
mveRichard Deeming18-Nov-14 3:53 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.