Sparta23

My wife is in another nagging session, she said I don't initiate affection, which I don't believe is true. I kiss her when leaving out the house, etc.

(Please respond from a biblical perspective) My wife woke up this morning and wanted to have sex. I was not really awake, so I declined in declining my wife begins to fight with me while I have yet to come to my senses. Once I do realize, her argument which was I turn her down when she initiates. Which I did, I'll admit that. However, I told her she is very quick to anger. And she could have approached the situation with a positive spin instead of always going negative. My real question is: Did I make sense of this woman always attacking her husband, yet not accomplishing the goal of a loving home? She mentioned a couple days ago, her turning me down. I said let's discuss that, when it happened to me I just practiced "Patience". I didn't get worked up and begin arguing over it, making the other person feel a certain way. Now I am angry cause the emotion of anger filled the house...

I have this store procedure in MySql, that I need to evaluate a condition and make a choice between 2 different CALL functions that call 2 different store procedures.

Not sure if I can split the select statements up like this...

Here is my code it is a store procedure that I would like to give back the information it does already (without the condition) or give me back the modified version :

PROCEDURE `getPositionGrid`(in varID int)

BEGIN

DECLARE varID int

IF(varID == NULL) THEN

SELECT pos_id as strValue

, pos_ipnumber as `strIPnumber`

, pos_sn as strSN

, posn_name as strPosTitle

, IFNULL(IF(loc.loc_provinceorder < 10,CONCAT("0",loc.loc_provinceorder,loc.loc_province),CONCAT(loc.loc_provinceorder,loc.loc_province)),"00") AS strOffice

, grd_name as strGrade

, loc.loc_region as strRegion

, IFNULL(loc.loc_city,"") AS 'strDivision'

FROM tbl_positions pos

INNER JOIN tbl_position_names pn

ON pn.posn_id = pos.posn_id

INNER JOIN tbl_locations loc

ON loc.loc_id = pos.loc_id

INNER JOIN tbl_office_region off

ON off.off_sdo_id = pos.pos_sdo_id

LEFT JOIN tbl_grade grd

ON grd.grd_id = pos.grd_id

WHERE pos_active = 1

ORDER BY loc.loc_provinceorder;

ELSE

SELECT pos_id as strValue

, pos_ipnumber as `strIPnumber`

, pos_sn as strSN

, posn_name as strPosTitle

, IFNULL(IF(loc.loc_provinceorder < 10,CONCAT("0",loc.loc_provinceorder,loc.loc_province),CONCAT(loc.loc_provinceorder,loc.loc_province)),"00") AS strOffice

, grd_name as strGrade

, loc.loc_region as strRegion

, IFNULL(loc.loc_city,"") AS 'strDivision'

FROM tbl_positions pos

INNER JOIN tbl_position_names pn

ON pn.posn_id = pos.posn_id

INNER JOIN tbl_locations loc

ON loc.loc_id = pos.loc_id

LEFT JOIN tbl_grade grd

ON grd.grd_id = pos.grd_id

WHERE pos_active = 1

ORDER BY loc.loc_provinceorder;

END IF;

END

//

I know some people will say we only have one side of the story, but no this is the truth...I like to build this knigdom but she always finds a way to say the wrong things in anger..I can't take much more..She has a bad temper..

Atlanta, Dallas, Tennessee, Green Bay, New Orleans

SET NEW.tour_active = if(NEW.tour_otg > offsetTime(),2,if(offsetTime() between NEW.tour_otg and NEW.tour_depart + interval 1 day,1,IF(IFNULL(NEW.tour_otg,0)=0,2,0)));

I have tried to import my triggers, but the Workbench just doesn't like the syntax. To make matters worst it doen't have a selection for triggers. Only (Add Schema, Add Table, Add View, Add Routine) am I missing out on something. I have searched the internet as well on information pertaining to my gripe with no luck. Help, Thanks...

I have a query that i want to use in another query to help extract certain records of a certain tour_depart date. But, the date I am looking for are the date(s) greater than tour_depart but less than 120 days.

Here is what I have:

select DISTINCT (tour_depart) from tbl_tour where BETWEEN tour_depart AND (tour_depart - INTERVAL 120 DAY)

this is the code I want to use it gives a pop-up box:

setlStore(new ListStore<ModelData>());

if(isBlnForDelete())

{

MessageBox.confirm("Confirm Deletion", "You are about to delete a position.\n Are you sure you want to perform this operation?", new Listener<MessageBoxEvent>()

{

public void handleEvent(MessageBoxEvent ce)

{

Button btn = ce.getButtonClicked();

if (btn.getText().equalsIgnoreCase("Yes"))

{

final MessageBox box = MessageBox.wait("Progress", "", "Deleting Position...");

getlStore().addStoreListener(new StoreListener<ModelData>()

{

public void storeAdd(StoreEvent<ModelData> se)

{

box.close();

simple = new Dialog();

simple.setButtons(Dialog.OK);

simple.addText("Position Deleted!");

simple.setBodyStyleName("pad-text");

simple.setHideOnButtonClick(true);

simple.setBlinkModal(true);

simple.setModal(true);

simple.addWindowListener(new WindowListener()

{

public void windowHide(WindowEvent we)

{

getBtnReSubmit().fireEvent(Events.Select);

}

});

simple.show();

}

});

getDsQuery().getResponse(getlStore(), "DeletePosition&varID=" + getStrValueID(), new ModelTypes());

}

}

});

}

((STR_TO_DATE(strOTG,'%m/%d/%Y') NOT BETWEEN tour_otg AND tour_depart + INTERVAL 120 day)

tour_otg & tour_date are dates mm/dd/yyyy

I say this because it is apparent that the BECK rally produced nothing they could not get from their local church, then why gather like that? And why did BECKs' message change from government bashing to intervention of GOD?

I think they are being experimented on for three things, I call them the 3 R's...RESEARCH, REASONING, RESULT...

Research they give a stimulus such as race, taxes, fear, security...etc.

by the way this MAZE..

Reason they must give an account for why? This is the CHEESE which agenda needs to be attacked, who will can help get this done, can they produce another sheperd (Palin, Rush, Beck)

Result can vary depending on if they want them to remain Under their Control, or how much money is needed..