Search results 145

Sorted from new to old.

GeneratePostID

Two functions to generate ID that is unique (not found in database) ...

2019Dec19

List of Databases

Script to list databases available in a server using ADODB connection From

2019Oct6

bs_grid

Bootstrap grid with php server-side example code (jQuery Datagrid plugin) From ...

2019Sep20

Country list in arabic

List of countries codes and names in Arabic, you do not know when you need it ...

2019Sep9

Char(39) in SQL table

One of many ways to go around the issue of char 39 in SQL database

2019Aug31

FilesKill

Delete Multiple Files (with WildCards) To delete multiple files from a ...

2019Aug7

Rows 2 Cell

Convert items found in a column matching certain material into list in 1 cell ...

2019Jul30

DB_ExtendedProperties

Returns extended properties of a database, knowing the ADODB connection

2019Jul22

LastInsertedID_SQL

Get the ID of the last inserted record in a table. There are other methods, ...

2019Jul18

HeadingZeros Remove and Add

Adds or remove zeros at start of string Used to clear heading zeros from ...

2019May31

fnGenerateRandomString

SQL function to generate random string I thought it would be easier to find ...

2019May5

ANmaDB functions

Database functions, commonly used in my systems. Should be working for each ...

2019Apr14

SheetAdd_ANmar

Adds a sheet to a workbook, after checking if workbook is open Checks if ...

2019Apr1

DBMySQLVBA API

An API to allow connecting to MySQL database from VBA (or VB6), found it a ...

2019Feb3

MinIF and MaxIF in Excel 2010

MinIF to calculate smallest number matching certain criteria, in Excel 2010 ...

2019Feb1

API in ASP Classic

A simple REST API technique reading record from Access mdb, then generates json ...

2019Feb1

1 2 ...6 ...9 10