Index_M

M

MacHTTP, 27

Macintosh computer, Dreamweaver MX requirements, 13–14

Macromedia Exchange, 643, 650–656, 654

downloading from, 644

getting started, 650–654, 651, 652

log in, 651

searching, 652, 653

Macromedia JRun, 270, 271, 272

Macromedia, templates from, 616

Managed Data Provider for SQL Server, for ASP.NET developers, 237–238

Managed Provider for ADO.NET, 348

many-to-many relationships, 106, 107

foreign key for, 110

MapPath() method, of ASP Server object, 313

markup for HTML, 70

Master-Detail Forms concept, 532

Master/Detail Page Set Server Behavior, 545

Master/Detail Page Sets, 510, 543, 544

with ASP, 545–558

additional details, 560–564

Detail.asp, 557–558, 558, 559

Master.asp, 549–557, 558, 559

Recordset code, 546–547

building, 544–545

with ColdFusion, 578–583

Detail.cfm file, 581–583, 584

Master.cfm code, 580–581, 581

from components, 584–592

Detail page with ASP.NET, 589–592

Master page with ASP.NET, 584–588

drill-down model, 543–544

further information, 601

with JSP, 565–577

Detail.jsp code, 576–577, 578

Master.jsp code, 569–575, 577

Recordset code, 566–567

with PHP, 593–600

Detail page, 598–600, 600

dynamic table code in Master.php, 594–595, 595

Master.php file, 596–597

mathematical functions

in Access, 204–205

in Microsoft SQL Server, 165–166

mathematical operators in SQL, 463

Max function (SQL), 216, 468

MAX() function (MySQL), 147

MAX() function (Oracle), 124, 126

Max() function (T-SQL), 181

MaxRecords property, of MM:DataSet Custom tag, 355

McAfee, 412

MDB file, preparing for conversion to SQL Server, 218

MEDIUMINT datatype (MySQL), 143

Memo datatype (Access), 192

memory

Access requirements, 186

Dreamweaver MX requirements, 13–14

memory variables, for ColdFusion, 253

menus, drop-down, extension for building, 659–660

Meta Data functions, 167

meta tags, 54

microprocessor

Access requirements, 186

Dreamweaver MX requirements, 13–14

Microsoft Access

built-in functions, 194–207

aggregate functions, 206, 665–666

conversion functions, 197–199, 669–670

date/time functions, 200–203, 668–669

domain functions, 205–207

financial functions, 206–207

mathematical functions, 204–205

numeric functions, 666

string functions, 195–197, 667–668

connection options, 221

and database location, 28

datatypes, 669–670

Jet datatypes, 191–193

Jet SQL, 207–216

as data source, 210, 210–211

executing in code, 211–215

queries, 208–210

package, 185

as platform for Web development, 221

Query Design View, 208, 208–209

requirements, 186

SQL aggregate functions, 215–216

upsizing database to SQL Server, 182–184,216–220

planning, 217

web support, 186–191

Access projects for SQL Server Desktop, 187–190

Data Access Pages (DAP), 190

Office Web Components (OWC), 190–191

XML (Extensible Markup Language), 191

Microsoft Access 2000, 9–10

Microsoft error messages on database connections, 243–246

access permission problems, 244

Data source name not found, 246

SQL Server login failed, 245

SQL Server logon general failure, 246

too few parameters, 246

updating date column to empty string in Access, 246

Microsoft Intermediate Language (MSIL), 320

Microsoft Scripting Host, 7

Microsoft SQL Server, 430

comment tags, 47

components, 160–161

connection options, 184

and database location, 28

datatypes, 161–162, 669–670

editions, 157–158

functions, 162–169

aggregate functions, 665–666

conversion functions, 669–670

date/time functions, 163–164, 668–669

mathematical functions, 165–166

numeric functions, 666

string functions, 168–169, 667–668

system functions, 166–167

Transact-SQL use with, 169–182

aggregate functions, 179–182

SQL Server views, 169–171

stored procedures, 171–174

user-defined functions, 174–179

upsizing Access database to, 182–184,216–220

planning, 217

Web support, 158–160

URL (Uniform Resource Locator), 160

web-enabled analysis, 159

XML (Extensible Markup Language), 158–159

Microsoft SQL Server 2000, 9–10

Microsoft Windows Scripting Host, 295

Mid$() function (Access), 196

Min function (SQL), 216, 468

MIN() function (MySQL), 147

MIN() function (Oracle), 124–125, 126

Min() function (T-SQL), 181

Minute() function (Access), 202

MM:DataSet Custom tag, 353–358

Modify menu, ® Templates

® Apply Template To Page, 622

® Detach From Template, 622

® Make Attribute Editable, 635

Money datatype (SQL Server), 162

Month() function (Access), 202

Month() function (SQL Server), 164

MONTHNAME() function (MySQL), 152–153

MONTHS_BETWEEN() function (Oracle), 128

mouse, alternatives to, 57

Move To First Record Server Behavior, 548

Move To Last Record Server Behavior, 549

Move To Next Records Server Behavior, 549

Move To Previous Records Server Behavior, 548

MSIL (Microsoft Intermediate Language), 320

Muck, Tom, 658

multiline text input as HTML input element, 72

multistatement user-defined function, 178–179

multitasking, 5, 314–315

MySQL, 10

additional information, 156

comment tags, 47

datatypes, 141–146, 669–670

character, 144–145

date/time, 146

numeric, 142–144

and Dreamweaver MX and PHP, 140–141

functions, 147–153

aggregate functions, 665–666

conversion functions, 669–670

date/time functions, 151–153, 668–669

grouping functions, 147–148

numeric functions, 148–149, 666

string functions, 149–151, 667–668

and PHP, 387, 397, 399

syntax, 153–156

case sensitivity, 154

LOAD DATA INFILE statement, 155–156

SELECT...LIMIT statements, 154–155

strings and identifiers, 153–154

versions, 139–140

MySQL Connection dialog box, 242