...them up!
Unfortunately the DTC's do not refer to a stylesheet Class name - but this is very easy to fix. Anyway, here are a couple of ideas:
* Use stylesheets to fix ALL textboxes etc. - by creating styles for <INPUT..> of various types, TD/TR, BODY, P etc. etc.
and/or
* Update the code...
Find the global.asa file in the root of your web. Right click it and add the db connection there - i.e. select the ODBC driver and select your DSN name.
Make sure the web server also has the DSN name registered - and that it has a local copy of the MDB file. It usually has permissions problems...
For VI to 'see' a database, it needs to connect to the database in the same way as the server does. This means that if the connection uses ODBC, then make sure the ODBC DSN has been created on your local machine, as well as on the server. (this is why the Web runs OK - as it uses the...
In VI, you have two copies of web files - one on the master web server, and one local to your pc - often on the C or D drive. It sounds as though VI has problems reading or writing to the local copy of the web. Make sure the front-page server extensions is configured on the server...
You will need to adjust the code in _ScriptLibrary/DATAGRID.ASP
In the Display method (function _DG_display(bReturnText)
), find this block:
if (this.hasPageNumber)
{
strHTML += '<TD align=right valign=middle>';
strHTML += '<FONT size=2><NOBR>' + String(curPage+1) + ' / ' +...
...or view page source and type in the .js file name).
Both Access and SQLServer, and most other databases, understand months as short names.
************
PS...
The Timesheet system was developed in VI using DTCs - somewhat tweeked by me to give sub-totals in grids etc.
Then .Net came along...
If you get the date from Access into a RecordsetDTC, then the value is already converted to a string (by the RecorsetDTC code). This has some nasty implications, esp. if the International Settings on the server is US not UK!
You could look through the RecordsetDTC code in the _ScriptLibrary...
The FormatDateTime is not very flexible! Your best bet is to use the many functions to get the various bits of date out:
dtToday = Date
strDate = Day(dtToday) & "/" & Month(dtToday) ..etc
if you wanted two digit day & month try:
.. Right("0" & Day(dtToday), 2) ..
ttfn...
Your code looks correct, so there must be some other reason for failure.
Did you add a PageObjectDTC to the page? This creates the thisPage object against which the event runs.
Secondly, try some alerts to see what values are sent to the event.
In Interdev, try getting the Script Outline...
...Pick this, and the parameters will then be asked for. Just enter the DTC controls that you used for data entry here:
Sub pbSubmit_onclick()
'* if valid then...
Results.navigate.InitResultsPage(txtName.value, txtAge.value)
End Sub
Its easier to do than to explain - believe me...
Point taken.
It probably is a bug in Interdev - though it is not really designed to do this type of editing. It is really a developer (for code) tool.
Try getting a copy of HTMLKit, which we use (its like notepad for HTML).
www.corporateinternet.com
You may find that you can bash the data into an excel spreadsheet, and save it in HTML format. This gives you the Table rows, nicly sorted and so on.
Then you could use notepad, Interdev, Dreamweaver or whatever to adjust the formatting (Excel does add rather a lot of extra formatting info)...
No!
session is a SERVER SIDE object created by ASP.
cookies are a CLIENT SIDE feature, maintained by the browser. cookie values are sent with EVERY client request - so they should be kept small. ASP reads these cookie values, and places them into the request.cookies collection for you.
To...
In IE, look at Tools/Internet Options, then click the 'Settings' button in the Temporary Internet Files section. This shows you the place where cookies and other files are stored.
Cookies are stored here when your ASP code uses the Response.Cookies("Key").Value = "Fred"...
...myWeb/ShowNames.asp?Initial=A
The code could then put this initial letter into the SQL, via a RecordsetDTC (here called rsNames):
...SQL: SELECT * FROM tblNames WHERE Initial = ?
make sure the 'Automatically Open Recorset' property is NOT ticked.
Add a PageDTC, locate the ScriptOutline...
It takes a lot of effort to bind a debugger interface into any product. VI only knows about Internet Explorer for debugging (ie. for stepping thru code and viewing the values of variables etc.)
Windows authentication is only supported by some browsers - infact only IE, I think. This is...
I am not entirely sure what you mean. You may need to click onto the Script-Outline, or HTML Outline 'tab' of the toobox area. I use the Script-Outline view for adding Event-Handlers to my form pages - when using Design-Time-Controls (DTCs). If you do not know much HTML, then read a...
I move the items out of exchange to a separate (MIME complient) system. MAPI is the only product that provides the BCC information that I need (CDO blanks it out). But MAPI, which does not know or care about the message file format - it does not understand SMTP or offer a Stream to access the...
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.