pulpfiction
Members-
Posts
1,210 -
Joined
-
Last visited
About pulpfiction
- Birthday 06/13/1983
Profile Information
-
Location
Oklahoma
pulpfiction's Achievements
Dedicated Member (4/7)
0
Reputation
-
This adding parameter I can use in the report but cannot use it in SP parameter.Say if the query is like this. SELECT fldname FROM tlb WHERE id=@param.how can I give the value for @param
-
almost correct spelling.... Its "Adieu". also I think it means "goodbye".
-
Problem is after I select the SP....... i select the SP in the "database expert" [ole db (ado)] when I select the SP in the expert window is gets added but there are no fields in it. Are you telling about the "add command" under OLE DB. but the query I use requires parameters, how can I do that? Thanks.
-
No AFAIK, the reports must be designed manually and there's no other way to do that....
-
Its the same procedure in CR 9, but temp tables are messing it up. guess there's no other option other than to rewrite the SP. its gonna get really complex.
-
Tried to trace where the div open and close. seems like the container div "content_wrap" is closed after the "left_col" and the "welcome_join" and other divs are outside the container div. so they are moved to the bottom <div id="content_wrap"> <div id="left_col"> <div id="nav"> <ul class="nav"> <li class="item1"><a class="first" href= "index.php?src=gendocs&ref=AboutSampleCity&category=Main&PHPSESSID=3c0eea866da0ca0b84527386ee8eaa17">About Sample City</a></li> <li class="item2"><a href="index.php?src=gendocs&ref=AbouttheChamber&category=Main&PHPSESSID=3c0eea866da0ca0b84527386ee8eaa17">About the Chamber</a></li> <li class="item3"><a href="index.php?src=events&category=Events&PHPSESSID=3c0eea866da0ca0b84527386ee8eaa17">Programs & Events</a></li> <li class="item4"><a href="index.php?src=news&persist_cat=1&srctype=lister&newssearch=yes&kw=&PHPSESSID=3c0eea866da0ca0b84527386ee8eaa17">Press Room</a></li> <li class="item5"><a href="index.php?src=gendocs&ref=GovernmentAffairs&category=Main&PHPSESSID=3c0eea866da0ca0b84527386ee8eaa17">Government Affairs</a></li> <li class="item6"><a href="index.php?src=dining&persist_cat=1&srctype=lister&newssearch=yes&kw=&PHPSESSID=3c0eea866da0ca0b84527386ee8eaa17">Dining Guide</a></li> <li class="item7"><a href="index.php?src=nightlife&persist_cat=1&srctype=lister&newssearch=yes&kw=&PHPSESSID=3c0eea866da0ca0b84527386ee8eaa17">Nightlife Guide</a></li> <li class="item8"><a href="index.php?src=directory&view=businesses&view=businesses_lister&PHPSESSID=3c0eea866da0ca0b84527386ee8eaa17">Business Search</a></li> <li class="item9"><a href="index.php?src=products&persist_cat=1&srctype=lister&newssearch=yes&kw=&PHPSESSID=3c0eea866da0ca0b84527386ee8eaa17">Marketplace</a></li> <li class="item10"><a href="index.php?src=forum&PHPSESSID=3c0eea866da0ca0b84527386ee8eaa17">Members Forum</a></li> <li class="item11"><a href="index.php?src=faq&PHPSESSID=3c0eea866da0ca0b84527386ee8eaa17">FAQ</a></li> <li class="item12"><a href="index.php?src=blog&view=blog&PHPSESSID=3c0eea866da0ca0b84527386ee8eaa17">Chamber Blog</a></li> <li class="item13"><a href="index.php?src=gendocs&ref=AdvertisingInformation&category=Main&PHPSESSID=3c0eea866da0ca0b84527386ee8eaa17">Advertising Information</a></li> <li class="item14"><a class="last" href="index.php?src=forms&ref=Contact Us&PHPSESSID=3c0eea866da0ca0b84527386ee8eaa17">Contact</a></li> </ul> </div> <!-- END OF NAV --> <div id="poll"> <form action="index.php" method="post" style="margin-bottom:3;"><input type="hidden" name="PHPSESSID" value="3c0eea866da0ca0b84527386ee8eaa17" /> <div class="pollHomeQuestion">What is your favorite thing about Sample City?</div> <div class="pollHomeChoices"><input type="radio" name="myvote" value="1">The People</div> <div class="pollHomeChoices"><input type="radio" name="myvote" value="2">The Nightlife</div> <div class="pollHomeChoices"><input type="radio" name="myvote" value="3">The Events</div> <input type="hidden" name="id" value="1" /> <input type="hidden" name="src" value="poll" /> <input type="hidden" name="srctype" value="process" /> <input type="hidden" name="category" value="Polls" /> <div class="pollHomeVote"> <input type="image" src="http://www.samplechamber.com/graphics/vote.gif" border="0" name="vote" value="Vote" /> </div> </form> </div> <!-- END OF POLL --> <div id="banner"><p align="center"><a class="fba_links" href="index.php?src=fba&srctype=click&id=1&PHPSESSID=3c0eea866da0ca0b84527386ee8eaa17" onclick="window.open(this.href); return false;"><img src="cache/sql/fba/fs_1.jpg" style="border:0px;width:120px;height:90px" alt="Indy Star" /></a></p></div> </div> <!-- END OF LEFT_COL --></div> <!-- END OF CONTENT_WRAP --><!-- THIS DIV ABOVE MUST COME AFTER AT THE BOTTOM, JUST BEFORE THE FOOTER DIV --><!-- ======== Header Page Layout Ends ========= --><div id="welcomejoin">
-
I use VS 2003 and CR bundled with it. When I add a SP, it appears under "database fields" this SP must be expandable and must show the fields to drag into the report. but its not expandable at all. no [+] appears when SP is added. Also SP ends like SELECT fldname from #temp. Data from different tables are collected in a temp table.
-
After 2 weeks of struggling with CR finally found the work around. its to totally avoid dataset. you need to directly connect with the database [OLE DB]and pull the stored procedure. and add some CR connection info code. Next problem is, one of the stored procedures has temporary table and final data comes from a temp data. CR cannot use that SP. any suggestions? thanks.
-
The left div which contains the menu has a width:900px [covers the whole mid section]. reduce that width and float it to left. #content_wrap { width:200px; margin: 0 auto; text-align:left; float:left; border:1px solid #fff; }
-
I just tried to install Internet Explorer Developer Toolbar Beta 3. is this the latest version? its pretty much like FF's tool but graphically poor....http://www.microsoft.com/downloads/details...;displaylang=en
-
I like all the designs there except for "Retro Theater by Eric Roge"http://www.csszengarden.com/?cssfile=/202/202.css&page=0
-
FF Web Developer tool is awesome, "validate local CSS" and "validate local HTML" options are really helpful..... Never used it much, guess it should be nice.http://dev.opera.com/tools/
-
small change.... add "mailto:" to the radio button value.....<form id="theForm" action="mailto:person1@domain.com" method="post"><input type="radio" name="email" value="mailto:person1@domain.com" selected="selected" onclick="changeEmail(this)"/> person1<br/><input type="radio" name="email" value="mailto:person2@domain.com" onclick="changeEmail(this)"/> person2</form>
-
Not sure if you can do that in SQL. You must do that restriction with application...
-
MySql or SQLServer is better than MS Access.... http://64.233.167.104/search?q=cache:_6B8v...;cd=1&gl=usMySql and ASP connection..http://www.aspdev.org/articles/asp-mysql-connect/