Posts
 
Reputation
Joined
Last Seen
0 Reputation Points
Unknown Quality Score

No one has voted on any posts yet. Votes from other community members are used to determine a member's reputation amongst their peers.

0 Endorsements
~97 People Reached
Favorite Forums
Favorite Tags

1 Posted Topic

Member Avatar for cowen617

Hey I am using a trigger, if the trigger returns emtpy I want it to keep the data it already has. This is my trigger: [code]BEFORE INSERT SET NEW.calling_num = (SELECT users_name FROM cdr_phone_system_data WHERE extension_number = NEW.calling_num);[/code] How can I check if the return is blank? The idea is …

Member Avatar for genevish
0
97

The End.