May 11, 2000

Deleting Fields from Recordset Object

Question: I am using a disconnected recordset (adOpenStatic, adUseClient) which is obtained by executing a stored procedure using command an object. I tried to delete some fields from the recodset using rst.Fields.Delete “FieldName” syntax, only to get error saying this operation cannot be performed in this context. Any ideas why

XHTML and Javascript

Question: Can Javascript code be used in XHTML Web pages? Answer: Sure. The only real difference between XHTML and HTML is the consideration for ampersands and less than symbols. Thus, the following JavaScript code could be valid in HTML, but is not valid in XHTML: However, you can work around

Sending Null Values to a Required Field

Question: When I try to send some information to an access database through ASP, I get the following error: [Microsoft][ODBC Microsoft Access 97 Driver] Field ‘tablename.class’ can’t be a zero-length string. This is the code from my page: Set conn = Server.CreateObject(“ADODB.Connection”) data_source = “DBQ=” & Server.MapPath(“filename.mdb”) conn.Open “DRIVER={Microsoft Access

XML Schemas

Question: What is the difference between SOX schemas and XDR schemas? Answer: SOX schemas are more object-oriented (the name in fact means Schemas for Object-Oriented XML), allowing you to assign archetypes, restrict data types, and perform inheritance on such schemas. XDR (XML Data Reduced) is Microsoft’s early schema language implementation,

Save and Load

Question: Is there any way to do a incremental save using XMLDOMDocument (MSXML parser) and also loading part of the Document tree? Answer: A SaveInto or a LoadFrom command? As desirable as such a feature is, it doesn’t currently exist in the MSXML parser, although that may change with the

Searching a Database for a Keyword

Question: When setting up a recordset, is it possible to get a record when the field contains more than the word that I’m looking for and where the words are in no particular order? For example: StrName = ‘Direct’ RSShops = Server.CreateObject(“ADODB.Recordset”) strSql = “SELECT * FROM Shops WHERE Name