Recent content by syukna

I have a stored procedure that is currently utilizing a user defined function. I need to use these functions because I'm returning one row with general info (IE: Name, Title, etc), and within that same row I return all the fiscal years associated to the item as a single field in the result set...

I ended up being an issue with our exchange server not allowing emails to be sent out from an email address that doesn't exist. Thanks for the help Zel

Relaying is allowed. I can send mail through command prompt and outlook express. I'm running out of ideas... :-\

Hi: I have a web application that can send email within our domain without any issues. Sending emails outside of the domain does not throw an error in our web application (ie: unresolved address), but the intended recipient does not receive the email. We have logged onto the web server...

I dunno if this will help, but in the gottopage function put this javascript:gotopage(2); put this function gotopage(pageIndex) { window.location.href='www.mypage' + pageIndex + '.com'; }

I understand things can get screwed up along the way. I didn't mean to offend you if I did. I really appreciate the help. As far as translating the query. The query I put up is the exact query with different words for "occasion" and "criteria". I got an ambiguous column error when I didn't...

Hi ESquared: After looking at your stored procedure and converting it to what I need it doesn't actually return the correct result set. It returns only the ones from tblOccasion matching the criteria. Anyways again I apprecate your help. For now I think I'll just stick to what I had above.

Hey thanks a lot for the help guys. I appreciate it....I only had to type Occasion once when I did a find and replace :)

I guess a more specific question. How would I write this query w/o using the keyword IN? *The names have been changed to protect the innocent ;) select OccasionID from tblOccasions where OccasionCriteria1 in ('A', 'B') or OccasionCriteria2 in ('A', 'B') or OccasionID in (select OccasionID...

I understand how simple joins work, but do you guys have a good article on advanced joins?

Yes the tables are different tables. One will only return 7 rows while the other theoretically could be endless but will usually not hold more than 100 records.

Yup, makes perfect sense. I took out the unions and just used something like this SELECT myID FROM table1 WHERE myCriteria IN ('A', 'B') OR myID IN (SELECT myID FROM Table2 WHERE myCriteria IN('A', 'B')) OR myID IN (SELECT myID FROM Table3 WHERE myCriteria IN('A', 'B')) etc... Would it be...

I may be wrong, but I thought union omitted non distinct records and union all puts them in regardless.

I think I may have figured it out. I'm gonna write a bunch of select's to union all the ID's together where the criteria is in the table. Then set a flag in the result set I send back to the page to populate the grid, and disable the links based on that flag. Is there a better way than this...

I agree that making 6 or 700 calls in the stored procedure is probably not the best way to do things. I have Admin rights to the server. I'm essentially trying to deactive a hyperlink in the grid based on a certain criteria for each row. How would I write a stored procedure to associate the...