eramgarden

Can you see the constraint when you open the table in design mode from EM?

Do a search for Mike55 on this forum. He started a thread on .net and the CRViewer that comes with it.

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpref/html/frlrfsystemdatadatasetclasscleartopic.asp see if that helps

You have: strTableQuery = "WallPortNo" strSqlQuery = "SELECT * from PermanentAssets WHERE strTableQuery = '*'" You need to change that to the variable: strTableQuery = "WallPortNo" strSqlQuery = "SELECT * from PermanentAssets WHERE " + strTableQuery + "= '*'"

what do u see for that value? can u tpdate the db with that value using sql?

i think linkbutton has a "Target" property that u can use.

"the input is not in correct format."...do you have correct values? Put a debug step and look at the values to make sure.

are u getting the info from database in SQL? if so, you do "select whatever, whatever, isnull(telephoneNumber,'') from whereever.."

do a search for crystal report viewer. u might find examples.

can u do a replace null with blank in the sql? isnull(FieldIdx,'') as FieldIdx , then u can check for blank.

this is an example: http://davidhayden.com/blog/dave/archive/2004/03/16/178.aspx

but why do u want to do it this way?? That app I worked with..the ex-developer wrote it.. I can copy and paste one routine for u if u want to see how he did it..

i worked on an ASP/VB6 once that built the ASP HTML table in the VB6 dll.. It would pass it , for example, a paramater and then based on that the dll either built a text area or a table with radiobuttons in it... It read the table header from the database.

copy and paste : OleDbException (0x80004005): Could not use ''; file already in use into google and click "groups". The first 2 search results might be of help.

I'd say hardcode the value and see if that works. That might give u a better idea into what's happening. Also, does the value work when u run the Stored Proc from the database?

I'd say start by asking them the fucntionality they're looking for. Then break down each section , do some research on it. This would give u a better idea.. I think you should add 2 hours to each section-time-estimate just in case u run into any bumbs along the road.. As for charging them..i think it depends on your experince. You might want to see how much consulting firms charge for their contractors and that would give u a better idea.

if u dont get an answer here, try http://www.sqlmag.com great site for sql questions

I'd say go to 4guysfromrolla.com. There's a comprehensive Datagrid tutorial from Scott Mitchell. That might your answer.

I'd say run the update statement in the database with the values u have to make sure your sql is correct. This might give u a better idea.

FIXED.. The dll resgistered under 'Project1" name and i was using the class name in Server.Create

I copied the dll this ex-developer had. Made changes, renamed it. Compiled it to a dll.. so far so good I registered the dll using Com+ in Component Services. I tried both interactive user and with userid/password . In the ASP code, i have; set oSvySII = Server.CreateObject ("CallerSurveySectionII.DisplaySecrionIICRM") But I get this error: 006~ASP 0177~Server.CreateObject Failed~Invalid ProgID. I did google, but nothing to help me resolve it. One site said to ignore it or something.. any ideas??

found answer: request.form("nameofradiobutton")

This is ASP NOT ASP.Net: My brain is just beyond fried.. I have 2 pages: page 1, page2. Page1 has 2 radiobuttons. I want to decide which one is selected and pass the value to the next page -- I have tried these: <input type="radio" name="Sec1" [b]value=<%session("TS")= "TS" %>[/b] ID="Radio2" >Technical Services<br> <input type="radio" name="Sec1" [b]value=<%session("PS")= "PS" %>[/b] ID="Radio3">Public Services<br> But both sessions have values in them when I click , for example, the first one. 2. <input type="radio" name="Sec1" value="DI" [b]onclick[/b]="<%session("DI")= "DI" %>" ID="Radio1">Director<br> <input type="radio" name="Sec1" value="TS" [b]onClick[/b]="<%session("TS")= "TS" %>" ID="Radio2" >Technical Services<br> Same issue as above 3. Used a function: ....onclick="Javascript:RadioValue('<%session("DI")= "DI" %>')" ... <script Language=JavaScript Runat=server> function RadioValue(XX){ } </script> But how do I save the value in a session variable in the function? Please HELP!

I have a VB6 dll from an ex-developer. I dont want to change his dll because I'm not sure what might break... I'm making some changes and I want to know if I can take his VB6 dll, copy the whole thing to a new dll and just make changes to the new dll.. I want to still resgister and use the orig dll as well Yes, no?

can u call a function, in that check the value of the textbox and set it accordingly? If u want examples of functions and how to check values like that..go to 4guysfromRolla, do a search for MorningZ posts. I had a similar question (but i wanted to check dates) and he recommanded using a function.