Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>a quick google found <a href="http://cwashington.netreach.net/depo/view.asp?Index=780" rel="noreferrer">this</a>... </p> <pre><code>@echo off goto :end_remarks ************************************************************************************* * * * authored:Sam Wofford * Returns lowercase of a string * 12:13 PM 11/13/02 ************************************************************************************** :end_remarks setlocal set errorlevel=-1 if {%1}=={} echo NO ARG GIVEN&amp;call :Help &amp;goto :endit if {%1}=={/?} call :Help &amp;goto :endit call :set_LCASE_array a b c d e f g h i j k l m n o p q r s t u v w x y z :start set input=%1 set input=%input:"=% set totparams=0 call :COUNT_PARAMS %input% call :MAKE_LOWERCASE %input% set errorlevel= echo %convertedstring% endlocal goto :eof :endit echo %errorlevel% endlocal goto :eof :MAKE_LOWERCASE :nextstring if {%1}=={} goto :eof set string=%1 set /a params+=1 set STRINGCONVERTED= set pos=0 :NEXT_CHAR set onechar=%%string^:^~%pos%,1%% for /f "tokens=1,2 delims==" %%a in ('set onechar') do for /f %%c in ('echo %%b') do call :checkit %%c if not defined STRINGCONVERTED goto :NEXT_CHAR shift /1 if %params% LSS %totparams% set convertedstring=%convertedstring% &amp;:add one space,but not at end goto :nextstring goto :eof :Help echo USAGE:%~n0 string OR %~n0 "with spaces" echo function returns the lowercase of the string or -1 (error) echo strings with embedded spaces needs to be in quotes Ex. "lower case" echo in a batch NTscript "for /f %%%%A in ('lcase STRING') do set var=%%%%A" set errorlevel= goto :eof :checkit set LCFOUND= if /i {%1}=={echo} set STRINGCONVERTED=Y&amp;goto :eof set char=%1 for /f "tokens=2 delims=_=" %%A in ('set LCASE_') do call :findit %%A %char% :skipit if defined LCFOUND (set convertedstring=%convertedstring%%ucletter%) else (set convertedstring=%convertedstring%%char%) set /a pos+=1 goto :eof :set_LCASE_array :setit if {%1}=={} goto :eof set LCASE_%1_=%1 SHIFT /1 goto :setit :findit if defined LCFOUND goto :eof set ucletter=%1 set lcchar=%2 if /i {%ucletter%}=={%lcchar%} set LCFOUND=yes goto :eof :COUNT_PARAMS :COUNTPARAMS if {%1}=={} goto :eof set /a totparams+=1 shift /1 goto :COUNTPARAMS </code></pre> <p>add that as a file (lowercase.cmd) to your path and you should be able to call it as "Lowercase.cmd %Username%", you could pipe it into another command if needed.</p>
    singulars
    1. This table or related slice is empty.
    1. POHow to convert the value of %USERNAME% to lowercase within a Windows batch script?
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USMauro
    1. USMauro
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. POHow to convert the value of %USERNAME% to lowercase within a Windows batch script?
      singulars
      1. PTQuestion
    1. This table or related slice is empty.
    1. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTAcceptedByOriginator
    2. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    3. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    1. COEw. Thanks for reminding me why I'm trying to sell PowerShell as the windows scripting solution at my org.
      singulars
      1. PO
      1. USGreg D
    2. COLOL...I haven't used command line for a looooong time, all my programming is now javascript, asp.net, c# and sql.
      singulars
      1. PO
      1. USMauro
    3. COThank you @Mauro :) I saved your posted script as "LCase.CMD", and I adjust LINE 11 with.. if not "%2"=="auto" setlocal then LINE 24 and 24 with.. if not "%2"=="auto" echo %convertedstring% if not "%2"=="auto" endlocal Now, I'm using this inline into my own batch file.. if exist "LCase.cmd" ( set convertedstring= call LCase.cmd %uid% auto set uid=%convertedstring% )
      singulars
      1. PO
      1. USRhak Kahr
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload