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
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.
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...
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 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...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.