pulpfiction

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

Adeui to you all!(thats probably wrong spelling..)

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.

then added a Sql Command

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

In CR 11 it allows SP, drag n drop datasource, and direct sql commands then in the designer you can drag all fields returned from the SELECT

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

Does anyone know about anything equivalent for Opera?

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/

It also says boen_robot is the topic starter..... can we delete our own post completly??

MD5 is a one-way hash algorithm. so you cannot retrive the password. One way to handle this is to reset the password [some random temporary password] and send it to user and update database with hashed new password...here's a site which reverses the md5 BUT method is by using several MD5 databases to look up an MD5 hash and return its original counterpart.http://md5.benramsey.com/

Sorry dont know the solution, by the process you mentioned, is this some kinda game... FLAMES its called right??

Are you looking for something like this...http://www.linkstraffic.net/programming/ja...ipt/movediv.php

If this is exactly how your code is, then you are missing a double quotes at the end of onmouseout event function call.... normally it onclick should not affect the other 2 events....<img name="home" width="150px" height="50px" src="Graphics/home1.gif" onmouseOver="mouseOver('home')" onmouseOut="mouseOut('home')" onclick="redirect()">

Try this......<script>DrawRow("Images/menuback.jpg")</script>\ is escape character in JShttp://www.htmlgoodies.com/beyond/javascri...cle.php/3470891

Try something like this.....

<script language="JavaScript">function redirect() {var browserName=navigator.appName; if (browserName=="Netscape"){ window.location = "URL for Netscape or FF";}else if (browserName=="Microsoft Internet Explorer") {window.location = "URL for IE"; }}</SCRIPT></head><body><input type="button" value="Click Me" onclick="java script:redirect();"/>.......

The code you posted sends mail, you can put it anywhere in the page and it will send mail. but if you want to do something like create a form and let the user fill in the message and their email and you want that message to be emailed to you, then it will be different. what is that you want to do?

Does this differ at all from the asp.NET code that does the same thing? I've been looking, but I can't find asp.NET code...

Its different in ASP.NET 1.1....http://www.developer.com/net/asp/article.php/3096831

One way to make the text not overflow is by padding.....Modify you CSS...#content { top: 200px; position: relative; left: 25px; color: #000000; width: 450px; height: 565px; padding-bottom: 29px; text-align: justify; padding: 10px; /*padding-left: 10px;*/ background: url(back.jpg); }

Similar problem....http://forums.devarticles.com/javascript-d...6-40t-8055.htmlhere's a discussion about floatingp oint number, [tried to understand, but couldnt] but might help you.http://www.merlyn.demon.co.uk/pas-real.htm#Float