Question: When using C++, is it better to use stack or free store memory for data objects of medium to large size? I have multiplatform concerns on the answer. The

Question: I’m trying to initialize a const declared in a class. How do I do this? This example fails: class MyClass {private: const int A;}MyClass::MyClass () { A = 1;}

Question: What is the C++ syntax for defining a function that belongs to a nested class that is contained within a template class? For example: template class A{ protected: //

Question: Is there a built-in or default string class in C++ or do I have to create my own? If so, what file can I look in to see the

Question: I’m new to the Standard Template Library. How do I incorporate a user-defined class into a hash_map? What functions do I need to overload? I get compiler errors when

Question: How can I obtain the address of a constructor for a C++ class object? Answer: A constructor is not an ordinary member function. You cannot take its address.

Question: Is it considered acceptable to use default argument initializers both in a definition of a function (e.g., void foo(int x =10) {…}) as well as its declaration? Stroustrup, in

Question: Can I take a string that is held in a table and use it as part of a SELECT statement? I need to do this because I have a

Question: I have two databases, each on a separate machine in a network. I want to generate a report extracting data from table1 in database1 and table2 in database2. How

Question: I have created a database of journal articles and want to offer users the ability to search the Author field for the surnames of authors. Most of the articles

Question: Can the latest version of ADO (ActiveX Data Objects) read and write an XML file as a recordset? Answer: Ah, let me qualify that: ADO 2.1 can currently produce

Question: How can I modify and update XML docs that are stored in the cache using a DCOM model (client side)? Answer: Given that caching is an IIS (Internet Information

Question: How do I truncate the last five characters in a field? (The string length varies from row to row.) Answer: Try something along these lines: select left(myfield, datalength(myfield)-5)

Question: How do I force a linefeed character using SQL? I created a report (see below) but when I e-mailed this report from Unix the carriage return was not interpreted

Question: I am trying to code an event that will transfer information from the current form into the display of another form. Information like company name and address, and contact

Question: Does XML work with VBA (Visual Basic for Applications)? I’m looking for a quick and easy way to store variable information that will be static once it has been

Question: I want to convert a signed integer into a 16-bit binary as part of a SELECT statement. For example: select myint, howeveritsdone as Binaryfrom mytablemyint Binary—- —————–137 1111111101110111-100 1111111110011100

Question: I want to add two numeric fields with values like these: Example 1: One field named Amount contains 565.25 and other field named Ticket contains null. select amount +

Question: How can I create a crosstab in SQL Server 7.0? I’m used to Microsoft Access, where I can use columnheading and rowheading. Does this work in SQL? Answer: This

Question: I have two tables and both tables have a one-to-many relationship. I want to add a new single record in the first “transheader” table (key is autonumber) and get

Question: How do I extract dates from SQL where the date type is a datetimestamp? I have the following SQL statement: select * from Patient where PatientDOB = “03/01/58” It

When the Visual InterDev Scripting Object Model (SOM) creates an option group object (a set of radio buttons), it selects the first radio button when the page loads. You may

If you need to calculate a time difference between your Web server and visitors to your site, look into the JavaScript getTimezoneOffset() method. It returns the time zone difference in

Question: I have WinNT4.0, Service Pack 5.0 SQL Server7.0, ODBC Driver for SQL 3.70.06.23. I have a servlet program that connects to a JDBC-ODBC bridge and accesses the database. If

Question: I am running SQL Server 7.0 with 20 user licenses. I have about 40 users, of which only 10 are logged on at once. The problem I am running

Question: When I try to import data to SQL, I find a problem in exporting the date values that occur earlier than the year 1752. Since I am working in

Question: I own a company and have two database servers. One is MS SQL6.5 and the other is a Sybase server. I want to access both servers on a client

Question: My question is simple, yet I can’t seem to find any help on it. I cannot add records to any of the tables in my SQL database. All the

Question: We currently have two contact databases in ACT. One of them is growing exponentially and at 70,000 records we are already experiencing problems. We are considering switching to MS

Question: I have two fields in my query: SELECT minutes, cost FROM SomeTable However, I would like to calculate the cost/minutes for each row selected. So I tried the following: