Search results for query: *

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...

Hi thanks for the quick response. Unfortunately the application was coded in a way where it would be extremly time consuming to change the spGetAllMyInfo procedure. I agree with you that there probably is a better way, but I can only work with what they gave me. :) I can't actually post the...

Hi, I have a stored procedure that gets data to populate a grid. Due to new business logic I need to now look at all of the data for each row in the grid. Each row item has about 20 tables associated with it. I'm wondering if there is a way to essentially loop through a dataset but using a...

Oops I had thought I posted this in the Windows XP forum. My bad. They're both running WinXP.

I have two computers. One is hardwired into the router and the other is using a usb wireless adapter. I'm having a hard time getting the two to be on the same network. Can anyone direct me as to where I might find information on how to connect the two. Thanks so much!

Hi, I've been wondering for a long time now how to reference other windows on the screen. Let's use AIM for an example. If I want to create a Windows App that will send text to an Instant Message screen how would I reference that? I figure AIM may have some kind of API that I can do that...